/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.203
 Source Server Type    : PostgreSQL
 Source Server Version : 120008 (120008)
 Source Host           : 192.168.1.203:11001
 Source Catalog        : app
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 120008 (120008)
 File Encoding         : 65001

 Date: 31/07/2024 17:36:44
*/


-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS "public"."banner";
CREATE TABLE "public"."banner"
(
    "id"             int8 NOT NULL,
    "img"            varchar(255) COLLATE "pg_catalog"."default",
    "url"            varchar(255) COLLATE "pg_catalog"."default",
    "des"            varchar(255) COLLATE "pg_catalog"."default",
    "sort"           int4,
    "create_time"    int8 NOT NULL,
    "create_user_id" int8 NOT NULL,
    "update_time"    int8 NOT NULL,
    "update_user_id" int8 NOT NULL
)
;
ALTER TABLE "public"."banner" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."banner"."id" IS '主键';
COMMENT
ON COLUMN "public"."banner"."img" IS '图片';
COMMENT
ON COLUMN "public"."banner"."url" IS '跳转';
COMMENT
ON COLUMN "public"."banner"."des" IS '描述';
COMMENT
ON COLUMN "public"."banner"."sort" IS '排序';
COMMENT
ON COLUMN "public"."banner"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."banner"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."banner"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."banner"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."banner" IS 'banner管理表-cud';

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO "public"."banner" ("id", "img", "url", "des", "sort", "create_time", "create_user_id", "update_time",
                               "update_user_id")
VALUES (30, 'file/download/1/1720449580684/favicon.ico', '3', '1', 2, 1699793910808, 1, 1720596652599, 1);
COMMIT;

-- ----------------------------
-- Table structure for coupon
-- ----------------------------
DROP TABLE IF EXISTS "public"."coupon";
CREATE TABLE "public"."coupon"
(
    "id"                  int8                                        NOT NULL,
    "name"                varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "start_time"          int8                                        NOT NULL,
    "end_time"            int8                                        NOT NULL,
    "on_shelf"            varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "specified_product"   varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "designated_products" text COLLATE "pg_catalog"."default",
    "amount_full"         numeric(10, 2)                              NOT NULL,
    "amount_reduce"       numeric(10, 2)                              NOT NULL,
    "quantity"            int4                                        NOT NULL,
    "received_quantity"   int4                                        NOT NULL,
    "sort"                int4                                        NOT NULL,
    "create_time"         int8                                        NOT NULL,
    "create_user_id"      int8                                        NOT NULL,
    "update_time"         int8                                        NOT NULL,
    "update_user_id"      int8                                        NOT NULL
)
;
ALTER TABLE "public"."coupon" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."coupon"."id" IS '优惠卷ID';
COMMENT
ON COLUMN "public"."coupon"."name" IS '名称';
COMMENT
ON COLUMN "public"."coupon"."start_time" IS '开始时间';
COMMENT
ON COLUMN "public"."coupon"."end_time" IS '结束时间';
COMMENT
ON COLUMN "public"."coupon"."on_shelf" IS '上架';
COMMENT
ON COLUMN "public"."coupon"."specified_product" IS '商品卷';
COMMENT
ON COLUMN "public"."coupon"."designated_products" IS '指定商品';
COMMENT
ON COLUMN "public"."coupon"."amount_full" IS '满额';
COMMENT
ON COLUMN "public"."coupon"."amount_reduce" IS '减额';
COMMENT
ON COLUMN "public"."coupon"."quantity" IS '数量';
COMMENT
ON COLUMN "public"."coupon"."received_quantity" IS '已领取数量';
COMMENT
ON COLUMN "public"."coupon"."sort" IS '排序';
COMMENT
ON COLUMN "public"."coupon"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."coupon"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."coupon"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."coupon"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."coupon" IS '优惠卷表';

-- ----------------------------
-- Records of coupon
-- ----------------------------
BEGIN;
INSERT INTO "public"."coupon" ("id", "name", "start_time", "end_time", "on_shelf", "specified_product",
                               "designated_products", "amount_full", "amount_reduce", "quantity", "received_quantity",
                               "sort", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (2, '满100减30通用卷', 1720540800000, 1752163199999, '1', '0', '[]', 100.00, 30.00, 100, 0, 1, 1720593180167, 1,
        1720595524539, 1);
COMMIT;

-- ----------------------------
-- Table structure for course_category
-- ----------------------------
DROP TABLE IF EXISTS "public"."course_category";
CREATE TABLE "public"."course_category"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "icon_img"       varchar(255) COLLATE "pg_catalog"."default",
    "is_hot"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "sort"           int8                                        NOT NULL,
    "pid"            int8                                        NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."course_category" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."course_category"."id" IS 'ID';
COMMENT
ON COLUMN "public"."course_category"."name" IS '名称';
COMMENT
ON COLUMN "public"."course_category"."icon_img" IS '图标';
COMMENT
ON COLUMN "public"."course_category"."is_hot" IS '是否热门';
COMMENT
ON COLUMN "public"."course_category"."sort" IS '排序';
COMMENT
ON COLUMN "public"."course_category"."pid" IS '父id|';
COMMENT
ON COLUMN "public"."course_category"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."course_category"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."course_category"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."course_category"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."course_category" IS '课程分类表-crud';

-- ----------------------------
-- Records of course_category
-- ----------------------------
BEGIN;
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (71, '财会金融', 'file/download/1/1720017275849/default-1000.png', '0', 1, 0, 1719201381703, 1, 1720017277805,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (72, '初级会计', 'file/download/1/1720017311844/default-1000.png', '0', 1, 71, 1719201381723, 1, 1720017313559,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (73, '中级会计', 'file/download/1/1720017921363/default-1017.png', '0', 2, 71, 1719201381742, 1, 1720017925887,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (74, '注册会计', 'file/download/1/1720017958472/default-1017.png', '0', 3, 71, 1719201381761, 1, 1720017959878,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (75, '税务师', 'file/download/1/1720017995870/default-1017.png', '0', 4, 71, 1719201381780, 1, 1720017997354, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (76, '初级经济师', 'file/download/1/1720018017755/default-1017.png', '0', 5, 71, 1719201381797, 1, 1720018019174,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (77, '中级经济师', 'file/download/1/1720018074762/default-1017.png', '0', 6, 71, 1719201381815, 1, 1720018076569,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (78, '基金从业', 'file/download/1/1720018194514/default-1017.png', '0', 7, 71, 1719201381833, 1, 1720018195670,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (79, '证券从业', 'file/download/1/1720018221512/default-1017.png', '0', 8, 71, 1719201381850, 1, 1720018222730,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (80, '银行从业', 'file/download/1/1720018240802/default-1017.png', '0', 9, 71, 1719201381870, 1, 1720018241783,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (81, '期货从业', 'file/download/1/1720018265514/default-1017.png', '0', 10, 71, 1719201381890, 1, 1720018267046,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (82, '初级审计师', 'file/download/1/1720018287820/default-1017.png', '0', 11, 71, 1719201381910, 1,
        1720018288905, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (83, '中级审计师', 'file/download/1/1720018309539/default-1017.png', '0', 12, 71, 1719201381930, 1,
        1720018310887, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (84, '初级管理会计', 'file/download/1/1720018331258/default-1017.png', '0', 13, 71, 1719201381948, 1,
        1720018332165, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (85, '职业资格', 'file/download/1/1720018347537/default-1017.png', '0', 2, 0, 1719201381965, 1, 1720018348807,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (86, '幼儿教师（笔试）', 'file/download/1/1720018562669/default-1017.png', '0', 1, 85, 1719201381983, 1,
        1720018563833, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (87, '小学教师（笔试）', 'file/download/1/1720018583971/default-1017.png', '0', 2, 85, 1719201382001, 1,
        1720018585034, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (88, '初中教师（笔试）', 'file/download/1/1720018604371/default-1017.png', '0', 3, 85, 1719201382020, 1,
        1720018605939, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (89, '高中教师（笔试）', 'file/download/1/1720018626579/default-1017.png', '0', 4, 85, 1719201382038, 1,
        1720018628052, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (90, '面试', 'file/download/1/1720018643212/default-1017.png', '0', 5, 85, 1719201382058, 1, 1720018644275, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (91, '普通话水平测试', 'file/download/1/1720018663633/default-1017.png', '0', 6, 85, 1719201382076, 1,
        1720018664760, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (92, '导游资格证', 'file/download/1/1720018680247/default-1017.png', '0', 7, 85, 1719201382093, 1, 1720018681071,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (93, '初级社会工作师', 'file/download/1/1720018699445/default-1017.png', '0', 8, 85, 1719201382110, 1,
        1720018700672, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (94, '中级社会工作师', 'file/download/1/1720018718882/default-1017.png', '0', 9, 85, 1719201382129, 1,
        1720018720134, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (95, '系统集成项目管理工程师（软考中级）', 'file/download/1/1720018745492/default-1017.png', '0', 10, 85,
        1719201382146, 1, 1720018746824, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (96, '信息系统项目管理师（软考高级）', 'file/download/1/1720018771889/default-1017.png', '0', 11, 85,
        1719201382167, 1, 1720018772933, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (97, '演出经纪人', 'file/download/1/1720018789702/default-1017.png', '0', 12, 85, 1719201382186, 1,
        1720018790676, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (98, '学历提升', 'file/download/1/1720018364417/default-1017.png', '0', 3, 0, 1719201382205, 1, 1720018365831,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (99, '成人高考', 'file/download/1/1720018816488/default-1017.png', '0', 1, 98, 1719201382224, 1, 1720018817883,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (100, '学位英语', 'file/download/1/1720018836806/default-1017.png', '0', 2, 98, 1719201382243, 1, 1720018838040,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (101, '研究生考试', 'file/download/1/1720018856362/default-1017.png', '0', 3, 98, 1719201382264, 1,
        1720018857497, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (102, '自学考试', 'file/download/1/1720018877539/default-1017.png', '0', 4, 98, 1719201382284, 1, 1720018878724,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (103, '英语四级', 'file/download/1/1720018897635/default-1017.png', '0', 5, 98, 1719201382303, 1, 1720018898949,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (104, '英语六级', 'file/download/1/1720018919455/default-1017.png', '0', 6, 98, 1719201382322, 1, 1720018920677,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (105, '军队文职', 'file/download/1/1720018386586/default-1017.png', '0', 4, 0, 1719201382341, 1, 1720018387679,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (106, '管理类', 'file/download/1/1720018947145/default-1017.png', '0', 1, 105, 1719201382360, 1, 1720018948214,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (107, '经济类', 'file/download/1/1720018963518/default-1017.png', '0', 2, 105, 1719201382378, 1, 1720018964778,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (108, '医学类', 'file/download/1/1720018987387/default-1017.png', '0', 3, 105, 1719201382396, 1, 1720018988895,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (109, '药学类', 'file/download/1/1720019003343/default-1017.png', '0', 4, 105, 1719201382413, 1, 1720019004274,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (110, '理工类', 'file/download/1/1720019024505/default-1017.png', '0', 5, 105, 1719201382431, 1, 1720019025658,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (111, '文体教育类', 'file/download/1/1720019041933/default-1017.png', '0', 6, 105, 1719201382449, 1,
        1720019042906, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (112, '图书档案类', 'file/download/1/1720019060582/default-1017.png', '0', 7, 105, 1719201382466, 1,
        1720019061816, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (113, '语言类', 'file/download/1/1720019078445/default-1017.png', '0', 8, 105, 1719201382485, 1, 1720019079782,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (114, '艺术类', 'file/download/1/1720019100239/default-1017.png', '0', 9, 105, 1719201382502, 1, 1720019101072,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (115, '营房管理', 'file/download/1/1720019120213/default-1017.png', '0', 10, 105, 1719201382521, 1,
        1720019121114, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (116, '炊事员', 'file/download/1/1720019149668/default-1017.png', '0', 11, 105, 1719201382541, 1, 1720019150862,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (117, '公务员/文印员', 'file/download/1/1720019178508/default-1017.png', '0', 12, 105, 1719201382559, 1,
        1720019179485, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (118, '司机/交通运输', 'file/download/1/1720019200507/default-1017.png', '0', 13, 105, 1719201382576, 1,
        1720019201645, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (119, '保管类', 'file/download/1/1720019219043/default-1017.png', '0', 14, 105, 1719201382594, 1, 1720019220239,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (120, '卫生勤务类', 'file/download/1/1720019236839/default-1017.png', '0', 15, 105, 1719201382612, 1,
        1720019237954, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (121, '工商管理类', 'file/download/1/1720019256692/default-1017.png', '0', 16, 105, 1719201382634, 1,
        1720019257845, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (122, '建筑工程', 'file/download/1/1720018407470/default-1017.png', '0', 5, 0, 1719201382652, 1, 1720018408721,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (123, '一级建造师', 'file/download/1/1720019566795/default-1017.png', '0', 1, 122, 1719201382670, 1,
        1720019567834, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (124, '二级建造师', 'file/download/1/1720019590220/default-1017.png', '0', 2, 122, 1719201382688, 1,
        1720019591260, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (125, '一级造价工程师', 'file/download/1/1720019609782/default-1017.png', '0', 3, 122, 1719201382705, 1,
        1720019611018, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (126, '一级注册消防工程师', 'file/download/1/1720019627799/default-1017.png', '0', 4, 122, 1719201382725, 1,
        1720019628757, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (127, '二级注册消防工程师', 'file/download/1/1720019645412/default-1017.png', '0', 5, 122, 1719201382744, 1,
        1720019646333, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (128, '消防设施操作员', 'file/download/1/1720019668150/default-1017.png', '0', 6, 122, 1719201382764, 1,
        1720019669475, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (129, '监理工程师', 'file/download/1/1720019689861/default-1017.png', '0', 7, 122, 1719201382783, 1,
        1720019691015, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (130, '中级注册安全工程师', 'file/download/1/1720019708636/default-1017.png', '0', 8, 122, 1719201382802, 1,
        1720019709537, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (131, '注册城乡规划师', 'file/download/1/1720019727636/default-1017.png', '0', 9, 122, 1719201382824, 1,
        1720019728403, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (132, '安全员', 'file/download/1/1720018428511/default-1017.png', '0', 6, 0, 1719201382843, 1, 1720018429568, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (133, '全国版', 'file/download/1/1720020059074/default-1017.png', '0', 1, 132, 1719201382862, 1, 1720020060379,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (134, '江苏省', 'file/download/1/1720020082175/default-1017.png', '0', 2, 132, 1719201382880, 1, 1720020083145,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (135, '浙江省', 'file/download/1/1720020105324/default-1017.png', '0', 3, 132, 1719201382899, 1, 1720020106688,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (136, '河北省', 'file/download/1/1720020125776/default-1017.png', '0', 4, 132, 1719201382917, 1, 1720020126608,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (137, '四川省', 'file/download/1/1720020145448/default-1017.png', '0', 5, 132, 1719201382934, 1, 1720020146656,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (138, '广西省', 'file/download/1/1720020163715/default-1017.png', '0', 6, 132, 1719201382952, 1, 1720020164478,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (139, '广东省', 'file/download/1/1720020182559/default-1017.png', '0', 7, 132, 1719201382969, 1, 1720020183368,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (140, '北京市', 'file/download/1/1720020199373/default-1017.png', '0', 8, 132, 1719201382987, 1, 1720020200295,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (141, '天津市', 'file/download/1/1720020218581/default-1017.png', '0', 9, 132, 1719201383006, 1, 1720020219737,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (142, '上海市', 'file/download/1/1720020237429/default-1017.png', '0', 10, 132, 1719201383023, 1, 1720020238661,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (143, '重庆市', 'file/download/1/1720020261743/default-1017.png', '0', 11, 132, 1719201383043, 1, 1720020262852,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (144, '山西省', 'file/download/1/1720020281177/default-1017.png', '0', 12, 132, 1719201383061, 1, 1720020282061,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (145, '辽宁省', 'file/download/1/1720020298227/default-1017.png', '0', 13, 132, 1719201383077, 1, 1720020299344,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (146, '吉林省', 'file/download/1/1720020316696/default-1017.png', '0', 14, 132, 1719201383095, 1, 1720020317864,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (147, '黑龙江省', 'file/download/1/1720020338804/default-1017.png', '0', 15, 132, 1719201383113, 1,
        1720020339467, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (148, '安徽省', 'file/download/1/1720020358949/default-1017.png', '0', 16, 132, 1719201383130, 1, 1720020359748,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (149, '福建省', 'file/download/1/1720020383574/default-1017.png', '0', 17, 132, 1719201383147, 1, 1720020384476,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (150, '江西省', 'file/download/1/1720020399789/default-1017.png', '0', 18, 132, 1719201383168, 1, 1720020400753,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (151, '山东省', 'file/download/1/1720020420952/default-1017.png', '0', 19, 132, 1719201383186, 1, 1720020422127,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (152, '河南省', 'file/download/1/1720020440552/default-1017.png', '0', 20, 132, 1719201383204, 1, 1720020441311,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (153, '湖北省', 'file/download/1/1720020456979/default-1017.png', '0', 21, 132, 1719201383220, 1, 1720020457981,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (154, '湖南省', 'file/download/1/1720020478160/default-1017.png', '0', 22, 132, 1719201383236, 1, 1720020478941,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (155, '海南省', 'file/download/1/1720020494977/default-1017.png', '0', 23, 132, 1719201383272, 1, 1720020495941,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (156, '贵州省', 'file/download/1/1720020513649/default-1017.png', '0', 24, 132, 1719201383312, 1, 1720020514419,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (157, '云南省', 'file/download/1/1720020530512/default-1017.png', '0', 25, 132, 1719201383333, 1, 1720020531650,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (158, '陕西省', 'file/download/1/1720020556288/default-1017.png', '0', 26, 132, 1719201383350, 1, 1720020557413,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (159, '甘肃省', 'file/download/1/1720020573295/default-1017.png', '0', 27, 132, 1719201383367, 1, 1720020574313,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (160, '青海省', 'file/download/1/1720020591359/default-1017.png', '0', 28, 132, 1719201383385, 1, 1720020592367,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (161, '内蒙古', 'file/download/1/1720020610191/default-1017.png', '0', 29, 132, 1719201383402, 1, 1720020611312,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (162, '西藏', 'file/download/1/1720020630310/default-1017.png', '0', 30, 132, 1719201383418, 1, 1720020631106,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (163, '宁夏', 'file/download/1/1720020653199/default-1017.png', '0', 31, 132, 1719201383435, 1, 1720020653953,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (164, '新疆', 'file/download/1/1720020672951/default-1017.png', '0', 32, 132, 1719201383451, 1, 1720020673924,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (165, '医药健康', 'file/download/1/1720018446409/default-1017.png', '0', 7, 0, 1719201383467, 1, 1720018447665,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (166, '执业药师', 'file/download/1/1720021027063/default-1017.png', '0', 1, 165, 1719201383484, 1, 1720021027809,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (167, '临床执业医师', 'file/download/1/1720021049747/default-1017.png', '0', 2, 165, 1719201383501, 1,
        1720021050648, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (168, '临床执业助理医师', 'file/download/1/1720021112558/default-1017.png', '0', 3, 165, 1719201383517, 1,
        1720021113917, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (169, '口腔执业医师', 'file/download/1/1720021132276/default-1017.png', '0', 4, 165, 1719201383535, 1,
        1720021132978, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (170, '口腔执业助理医师', 'file/download/1/1720021148576/default-1017.png', '0', 5, 165, 1719201383551, 1,
        1720021149308, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (171, '中医执业医师', 'file/download/1/1720021170040/default-1017.png', '0', 6, 165, 1719201383567, 1,
        1720021174623, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (172, '中医执业助理医师', 'file/download/1/1720021191353/default-1017.png', '0', 7, 165, 1719201383604, 1,
        1720021192164, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (173, '中西医结合执业医师', 'file/download/1/1720021251258/default-1017.png', '0', 8, 165, 1719201383620, 1,
        1720021252866, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (174, '中西医结合执业助理医师', 'file/download/1/1720021269635/default-1017.png', '0', 9, 165, 1719201383637, 1,
        1720021270973, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (175, '卫生护理', 'file/download/1/1720018465262/default-1017.png', '0', 8, 0, 1719201383655, 1, 1720018466650,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (176, '执业护士', 'file/download/1/1720021314966/default-1017.png', '0', 1, 175, 1719201383672, 1, 1720021316826,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (177, '初级护师(护师)［203］', 'file/download/1/1720021340025/default-1017.png', '0', 2, 175, 1719201383688, 1,
        1720021341022, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (178, '主管护师(中级)［368］', 'file/download/1/1720021361157/default-1017.png', '0', 3, 175, 1719201383705, 1,
        1720021362530, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (179, '内科护理（中级）［369］', 'file/download/1/1720021387214/default-1017.png', '0', 4, 175, 1719201383721, 1,
        1720021388727, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (180, '外科护理（中级）［370］', 'file/download/1/1720021405934/default-1017.png', '0', 5, 175, 1719201383739, 1,
        1720021406972, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (181, '妇产科护理（中级）［371］', 'file/download/1/1720021423940/default-1017.png', '0', 6, 175, 1719201383755, 1,
        1720021425200, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (182, '儿科护理（中级）［372］', 'file/download/1/1720021445069/default-1017.png', '0', 7, 175, 1719201383772, 1,
        1720021446799, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (183, '社区护理（中级）［373］', 'file/download/1/1720021461924/default-1017.png', '0', 8, 175, 1719201383790, 1,
        1720021462874, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (184, '职业技能', 'file/download/1/1720018486964/default-1017.png', '0', 9, 0, 1719201383808, 1, 1720018488194,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (185, '互联网营销师', 'file/download/1/1720024785960/default-1017.png', '0', 1, 184, 1719201383825, 1,
        1720024786697, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (186, '全媒体运营师', 'file/download/1/1720024807126/default-1017.png', '0', 2, 184, 1719201383842, 1,
        1720024807964, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (187, '家庭教育指导师', 'file/download/1/1720024824904/default-1017.png', '0', 3, 184, 1719201383858, 1,
        1720024825632, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (188, '碳排放管理师', 'file/download/1/1720024843782/default-1017.png', '0', 4, 184, 1719201383875, 1,
        1720024844463, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (189, '三级健康管理师', 'file/download/1/1720024862263/default-1017.png', '0', 5, 184, 1719201383892, 1,
        1720024863020, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (190, '三级公共营养师', 'file/download/1/1720024878787/default-1017.png', '0', 6, 184, 1719201383908, 1,
        1720024880044, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (191, '心理咨询师（中科院）', 'file/download/1/1720024895127/default-1017.png', '0', 7, 184, 1719201383925, 1,
        1720024896628, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (192, '心理咨询师', 'file/download/1/1720024912075/default-1017.png', '0', 8, 184, 1719201383941, 1,
        1720024913042, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (193, '心理咨询师（二级）', 'file/download/1/1720024928911/default-1017.png', '0', 9, 184, 1719201383957, 1,
        1720024929815, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (194, '心理咨询师（三级）', 'file/download/1/1720024945553/default-1017.png', '0', 10, 184, 1719201383973, 1,
        1720024946405, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (195, '二级人力资源', 'file/download/1/1720024962451/default-1017.png', '0', 11, 184, 1719201383991, 1,
        1720024963405, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (196, '三级人力资源', 'file/download/1/1720024978393/default-1017.png', '0', 12, 184, 1719201384008, 1,
        1720024979146, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (197, '四级人力资源', 'file/download/1/1720024998215/default-1017.png', '0', 13, 184, 1719201384025, 1,
        1720024999150, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (198, '保育员', 'file/download/1/1720025015661/default-1017.png', '0', 14, 184, 1719201384040, 1, 1720025016632,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (199, '初级育婴师（五级）', 'file/download/1/1720025030750/default-1017.png', '0', 15, 184, 1719201384057, 1,
        1720025031711, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (200, '中级育婴师（四级）', 'file/download/1/1720025047515/default-1017.png', '0', 16, 184, 1719201384075, 1,
        1720025048668, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (201, '初级茶艺师', 'file/download/1/1720025067490/default-1017.png', '0', 17, 184, 1719201384092, 1,
        1720025068387, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (202, '中级茶艺师', 'file/download/1/1720025086010/default-1017.png', '0', 18, 184, 1719201384109, 1,
        1720025086866, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (203, '初级养老护理员', 'file/download/1/1720025101644/default-1017.png', '0', 19, 184, 1719201384125, 1,
        1720025102415, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (204, '中级养老护理员', 'file/download/1/1720025117984/default-1017.png', '0', 20, 184, 1719201384141, 1,
        1720025118948, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (205, '高级养老护理员', 'file/download/1/1720025134541/default-1017.png', '0', 21, 184, 1719201384158, 1,
        1720025135676, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (206, '公务员', 'file/download/1/1720018506008/default-1017.png', '0', 10, 0, 1719201384175, 1, 1720018507228,
        1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (207, '国家公务员', 'file/download/1/1720025157714/default-1017.png', '0', 1, 206, 1719201384192, 1,
        1720025158598, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (208, '北京公务员', 'file/download/1/1720025176052/default-1017.png', '0', 2, 206, 1719201384209, 1,
        1720025176925, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (209, 'A类江苏省公务员', 'file/download/1/1720025190211/default-1017.png', '0', 3, 206, 1719201384226, 1,
        1720025190985, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (210, 'B类江苏省公务员', 'file/download/1/1720025207525/default-1017.png', '0', 4, 206, 1719201384243, 1,
        1720025208651, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (211, 'C类江苏省公务员', 'file/download/1/1720025225252/default-1017.png', '0', 5, 206, 1719201384259, 1,
        1720025226589, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (212, '广东省公务员', 'file/download/1/1720025242041/default-1017.png', '0', 6, 206, 1719201384276, 1,
        1720025242842, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (213, '山东省公务员', 'file/download/1/1720025258549/default-1017.png', '0', 7, 206, 1719201384293, 1,
        1720025259392, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (214, '河南省公务员', 'file/download/1/1720025292526/default-1017.png', '0', 8, 206, 1719201384309, 1,
        1720025293722, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (215, '海南省公务员', 'file/download/1/1720025310696/default-1017.png', '0', 9, 206, 1719201384325, 1,
        1720025311258, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (216, '天津市公务员', 'file/download/1/1720025326641/default-1017.png', '0', 10, 206, 1719201384341, 1,
        1720025327266, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (217, '上海市公务员', 'file/download/1/1720025342236/default-1017.png', '0', 11, 206, 1719201384358, 1,
        1720025343433, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (218, '四川省公务员', 'file/download/1/1720025362715/default-1017.png', '0', 12, 206, 1719201384374, 1,
        1720025363505, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (219, '浙江省公务员', 'file/download/1/1720025383589/default-1017.png', '0', 13, 206, 1719201384392, 1,
        1720025384382, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (220, '重庆市公务员', 'file/download/1/1720025400948/default-1017.png', '0', 14, 206, 1719201384409, 1,
        1720025401694, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (221, '河北省公务员', 'file/download/1/1720025415752/default-1017.png', '0', 15, 206, 1719201384426, 1,
        1720025417005, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (222, '山西省公务员', 'file/download/1/1720025432670/default-1017.png', '0', 16, 206, 1719201384443, 1,
        1720025433533, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (223, '辽宁省公务员', 'file/download/1/1720025449278/default-1017.png', '0', 17, 206, 1719201384460, 1,
        1720025450575, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (224, '吉林省公务员', 'file/download/1/1720025465114/default-1017.png', '0', 18, 206, 1719201384484, 1,
        1720025466002, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (225, '黑龙江省公务员', 'file/download/1/1720025485564/default-1017.png', '0', 19, 206, 1719201384503, 1,
        1720025486477, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (226, '安徽省公务员', 'file/download/1/1720026560942/default-1017.png', '0', 20, 206, 1719201384520, 1,
        1720026561939, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (227, '陕西省公务员', 'file/download/1/1720026577295/default-1017.png', '0', 21, 206, 1719201384537, 1,
        1720026578363, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (228, '湖北省公务员', 'file/download/1/1720026593315/default-1017.png', '0', 22, 206, 1719201384555, 1,
        1720026594165, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (229, '青海省公务员', 'file/download/1/1720026610014/default-1017.png', '0', 23, 206, 1719201384572, 1,
        1720026610841, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (230, '湖南省公务员', 'file/download/1/1720026624170/default-1017.png', '0', 24, 206, 1719201384590, 1,
        1720026624988, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (231, '云南省公务员', 'file/download/1/1720026641689/default-1017.png', '0', 25, 206, 1719201384607, 1,
        1720026642953, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (232, '江西省公务员', 'file/download/1/1720026658051/default-1017.png', '0', 26, 206, 1719201384623, 1,
        1720026659113, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (233, '福建省公务员', 'file/download/1/1720026673922/default-1017.png', '0', 27, 206, 1719201384639, 1,
        1720026674824, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (234, '甘肃省公务员', 'file/download/1/1720026689234/default-1017.png', '0', 28, 206, 1719201384657, 1,
        1720026690316, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (235, '贵州省公务员', 'file/download/1/1720026709102/default-1017.png', '0', 29, 206, 1719201384673, 1,
        1720026709863, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (236, '宁夏省公务员', 'file/download/1/1720026722847/default-1017.png', '0', 30, 206, 1719201384689, 1,
        1720026723988, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (237, '内蒙古公务员',
        'https://s3.cn-north-1.amazonaws.com.cn/qingshuxuetang.com/YXK/pageSetting/courseGroup/default/default-3031.png',
        '0', 31, 206, 1719201384705, 1, 1720026744102, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (238, '新疆公务员', 'file/download/1/1720026761723/default-1017.png', '0', 32, 206, 1719201384722, 1,
        1720026762608, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (239, '西藏公务员', 'file/download/1/1720026777506/default-1017.png', '0', 33, 206, 1719201384738, 1,
        1720026778254, 1);
INSERT INTO "public"."course_category" ("id", "name", "icon_img", "is_hot", "sort", "pid", "create_time",
                                        "create_user_id", "update_time", "update_user_id")
VALUES (240, '广西公务员', 'file/download/1/1720026793835/default-1017.png', '0', 34, 206, 1719201384754, 1,
        1720026795074, 1);
COMMIT;

-- ----------------------------
-- Table structure for cron
-- ----------------------------
DROP TABLE IF EXISTS "public"."cron";
CREATE TABLE "public"."cron"
(
    "id"      int8 NOT NULL,
    "name"    varchar(255) COLLATE "pg_catalog"."default",
    "tag"     varchar(255) COLLATE "pg_catalog"."default",
    "code"    varchar(255) COLLATE "pg_catalog"."default",
    "url"     varchar(500) COLLATE "pg_catalog"."default",
    "token"   varchar(255) COLLATE "pg_catalog"."default",
    "json"    varchar(255) COLLATE "pg_catalog"."default",
    "version" int8,
    "state"   bool
)
;
ALTER TABLE "public"."cron" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."cron"."id" IS '主键';
COMMENT
ON COLUMN "public"."cron"."name" IS '任务名称';
COMMENT
ON COLUMN "public"."cron"."tag" IS '任务标识';
COMMENT
ON COLUMN "public"."cron"."code" IS '定时规则';
COMMENT
ON COLUMN "public"."cron"."url" IS '调用路径';
COMMENT
ON COLUMN "public"."cron"."token" IS '调用凭证';
COMMENT
ON COLUMN "public"."cron"."json" IS '入参';
COMMENT
ON COLUMN "public"."cron"."version" IS '执行版本';
COMMENT
ON TABLE "public"."cron" IS '定时任务表';

-- ----------------------------
-- Records of cron
-- ----------------------------
BEGIN;
INSERT INTO "public"."cron" ("id", "name", "tag", "code", "url", "token", "json", "version", "state")
VALUES (1, '清除过期临时文件夹', 'delete_temp_file', '0 */10 * * * ?', '/pt/task/deleteTempFile',
        'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MX0.SpJrriGA4UQQ6gpy4sN6evMsTWjaxaqjjcUhschZl_4', NULL, 0, 'f');
INSERT INTO "public"."cron" ("id", "name", "tag", "code", "url", "token", "json", "version", "state")
VALUES (2, '自动化测试', 'auto_code_test', '0 */10 * * * ?', '/pt/task/autoCodeTest',
        'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MX0.SpJrriGA4UQQ6gpy4sN6evMsTWjaxaqjjcUhschZl_4', NULL, 0, 'f');
COMMIT;

-- ----------------------------
-- Table structure for crud
-- ----------------------------
DROP TABLE IF EXISTS "public"."crud";
CREATE TABLE "public"."crud"
(
    "id"             numeric(20, 0) NOT NULL,
    "img"            varchar(200) COLLATE "pg_catalog"."default",
    "normal_text"    varchar(255) COLLATE "pg_catalog"."default",
    "number"         int8,
    "select_box"     varchar(50) COLLATE "pg_catalog"."default",
    "rich_text"      text COLLATE "pg_catalog"."default",
    "file"           varchar(200) COLLATE "pg_catalog"."default",
    "create_time"    numeric(20, 0),
    "create_user_id" int8,
    "update_time"    numeric(20, 0),
    "update_user_id" int8
)
;
ALTER TABLE "public"."crud" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."crud"."id" IS '主键';
COMMENT
ON COLUMN "public"."crud"."img" IS '图片地址';
COMMENT
ON COLUMN "public"."crud"."normal_text" IS '普通文本';
COMMENT
ON COLUMN "public"."crud"."number" IS '数字';
COMMENT
ON COLUMN "public"."crud"."select_box" IS '下拉框';
COMMENT
ON COLUMN "public"."crud"."rich_text" IS '富文本|';
COMMENT
ON COLUMN "public"."crud"."file" IS '文件地址';
COMMENT
ON COLUMN "public"."crud"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."crud"."create_user_id" IS '创建人';
COMMENT
ON COLUMN "public"."crud"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."crud"."update_user_id" IS '更新人';
COMMENT
ON TABLE "public"."crud" IS '模板表';

-- ----------------------------
-- Records of crud
-- ----------------------------
BEGIN;
INSERT INTO "public"."crud" ("id", "img", "normal_text", "number", "select_box", "rich_text", "file", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (1, 'file/download/1/1720449595068/favicon.ico', 'xxx_a_a', 7, '1', '<p>22</p>',
        'file/download/1/1720449600610/favicon.ico', 1699980222619, 1, 1720449602276, 1);
COMMIT;

-- ----------------------------
-- Table structure for library
-- ----------------------------
DROP TABLE IF EXISTS "public"."library";
CREATE TABLE "public"."library"
(
    "id"             int8                                        NOT NULL,
    "position"       text COLLATE "pg_catalog"."default"         NOT NULL,
    "position_id"    int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "img"            varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "file"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "sort"           int4                                        NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."library" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."library"."id" IS '主键';
COMMENT
ON COLUMN "public"."library"."position" IS '职位';
COMMENT
ON COLUMN "public"."library"."position_id" IS '职位id|';
COMMENT
ON COLUMN "public"."library"."name" IS '名称';
COMMENT
ON COLUMN "public"."library"."img" IS '封面';
COMMENT
ON COLUMN "public"."library"."file" IS '文件';
COMMENT
ON COLUMN "public"."library"."sort" IS '排序';
COMMENT
ON COLUMN "public"."library"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."library"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."library"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."library"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."library" IS '相关题库';

-- ----------------------------
-- Records of library
-- ----------------------------
BEGIN;
INSERT INTO "public"."library" ("id", "position", "position_id", "name", "img", "file", "sort", "create_time",
                                "create_user_id", "update_time", "update_user_id")
VALUES (2, '[71, 72]', 72, '初级会计_万人模考_第一轮.docx', 'file/download/1/1720016968353/下载.png',
        'file/download/1/1720017038671/初级会计_万人模考_第一轮.docx', 1, 1719362388143, 1, 1720017040147, 1);
COMMIT;

-- ----------------------------
-- Table structure for low_code_permission
-- ----------------------------
DROP TABLE IF EXISTS "public"."low_code_permission";
CREATE TABLE "public"."low_code_permission"
(
    "permission_id"  int8                                      NOT NULL,
    "param"          text COLLATE "pg_catalog"."default",
    "param_valid"    text COLLATE "pg_catalog"."default",
    "json"           text COLLATE "pg_catalog"."default",
    "response"       text COLLATE "pg_catalog"."default",
    "status"         varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
    "create_time"    int8                                      NOT NULL,
    "create_user_id" int8                                      NOT NULL,
    "update_time"    int8                                      NOT NULL,
    "update_user_id" int8                                      NOT NULL
)
;
ALTER TABLE "public"."low_code_permission" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."low_code_permission"."permission_id" IS '接口id';
COMMENT
ON COLUMN "public"."low_code_permission"."param" IS '参数格式内容';
COMMENT
ON COLUMN "public"."low_code_permission"."param_valid" IS '参数检验规则';
COMMENT
ON COLUMN "public"."low_code_permission"."json" IS '执行的json';
COMMENT
ON COLUMN "public"."low_code_permission"."response" IS '响应格式内容';
COMMENT
ON COLUMN "public"."low_code_permission"."status" IS '状态：优化用';
COMMENT
ON COLUMN "public"."low_code_permission"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."low_code_permission"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."low_code_permission"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."low_code_permission"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."low_code_permission" IS '低代码接口信息表';

-- ----------------------------
-- Records of low_code_permission
-- ----------------------------
BEGIN;
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (661, NULL, NULL, '', '', '1', 1699011949217, 1, 1699011949217, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (662, '{}', '{}', '({
  "[]": {
    Test: {
      "content~": req.content,
      "@order": "create_time-"
    },
    User: {
      "id@": "/Test/create_user_id",
      "@column": "id,name,account"
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 100
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]''].map(e => ({
    ...e.Test,
    user: e.User
  })),
  total: res.total
})', '1', 1691042689456, 1, 1691042689456, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (663, '{
    "content": "内容"
}', '{
    "content": {
        "type": "string",
        "required": "true"
    }
}', '({
  Test: {
    ...req,
    create_time: new Date().getTime(),
    create_user_id: system.id
  },
  "sql@": {
    with: false,
    from: "Test",
    "Test": {
      "@column": "id"
    }
  },
  "Test:del": {
    "@method": "delete",
    "status": "0"
  },
  "Test:put": {
    "@method": "put",
    "status": 0,
    "status{}": "=1",
    "@combine": "status{}"
  },
  "@explain": true
})', 'res', '1', 1691043725112, 1, 1691043725112, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (685, '{}', '{}', '(() => {
  let time = new Date().getTime()
  return {
    Test: {
      content: req.content,
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    },
    "Test[]": req.children.map(e => ({
      ...e,
      create_time: time,
      "create_user_id@": "Test/id",
      update_time: time,
      update_user_id: system.id
    }))
  }
})()', 'res', '1', 1694437822683, 1, 1694437822683, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (687, '', '', NULL, NULL, '1', 1699372819979, 1, 1699372819979, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (688, '{
  "id": "主键",
  "des-textArea": "描述",
  "img-img": "图片",
  "url": "跳转",
  "sort-number": "排序"
}', '{
  "id": {
    "type": "number",
    "required": "true"
  },
  "des": {
    "type": "string",
    "required": "true"
  },
  "img": {
    "type": "string",
    "required": "true"
  },
  "url": {
    "type": "string",
    "required": "true"
  },
  "sort": {
    "type": "number",
    "required": "false"
  }
}', '({
  Banner: {
    ...req,
    update_time: new Date().getTime(),
    update_user_id: system.id
  }
})', 'res', '1', 1720596553364, 1, 1720596553364, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (689, '{
    "pageIndex": "页码",
    "pageSize": "一页条数",
    "des": "描述",
    "create_time-dateTimeRange": "创建时间"
}', '{
    "pageIndex": {
        "required": false,
        "type": "number"
    },
    "pageSize": {
        "required": false,
        "type": "number"
    }
}', '({
  "[]": {
    Banner: {
      "des~": !!req.des ? req.des : null,
      "create_time&{}": (() => {
        if (!req.create_time) return null;
        let startTime = req.create_time[0];
        let endTime = req.create_time[1];
        let rules = [];
        if (startTime) rules.push(`>=${moment(startTime).valueOf()}`)
        if (endTime) rules.push(`<=${moment(endTime).valueOf()}`)
        return rules.length > 0 ? rules.join('','') : null
      })(),
      "@order": "sort+,create_time-",
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => e.Banner),
  total: res.total
})', '1', 1699372641825, 1, 1699372641825, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (690, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Banner: req
})', 'res', '1', 1699011418874, 1, 1699011418874, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (691, '{
    "des-textArea": "描述",
    "img-img": "图片",
    "sort-number": "排序",
    "url": "跳转"
}', '{
    "des": {
        "type": "string",
        "required": "true",
        "colProps": {
            "span": 2
        }
    },
    "img": {
        "type": "string",
        "required": "true"
    },
    "url": {
        "type": "string",
        "required": "true"
    },
    "sort": {
        "type": "number",
        "required": "false"
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Banner: {
      ...req,
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720596458508, 1, 1720596458508, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (709, '{
    "normal_text": "普通文本",
    "number-number": "数字",
    "select_box-select": "下拉框",
    "rich_text-editor": "富文本",
    "img-img": "图片地址",
    "file-file": "文件地址"
}', '{
    "id": {
        "type": "number",
        "required": "true"
    },
    "img": {
        "type": "string",
        "required": true
    },
    "file": {
        "type": "string",
        "required": true
    },
    "number": {
        "type": "number",
        "required": true
    },
    "rich_text": {
        "type": "string",
        "required": true,
        "width": 1200
    },
    "select_box": {
        "type": "string",
        "required": true,
        "select": [
            {
                "label": "是",
                "value": "1"
            },
            {
                "label": "否",
                "value": "0"
            }
        ]
    },
    "normal_text": {
        "type": "string",
        "required": true
    }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Crud: {
      ...req,
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720029222326, 1, 1720029222326, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (710, '{
    "pageIndex": "页码",
    "pageSize": "一页条数",
    "normal_text": "普通文本",
    "create_time-dateRange": "创建时间"
}', '{
    "pageIndex": {
        "required": false,
        "type": "number"
    },
    "pageSize": {
        "required": false,
        "type": "number"
    }
}', '({
  "[]": {
    Crud: {
      "normal_text~": !!req.normal_text ? req.normal_text : null,
      "create_time&{}": (() => {
        if (!req.create_time) return null;
        let startTime = req.create_time[0];
        let endTime = req.create_time[1];
        let rules = [];
        if (startTime) rules.push(`>=${moment(startTime).valueOf()}`)
        if (endTime) rules.push(`<=${moment(endTime).valueOf()}`)
        return rules.length > 0 ? rules.join('','') : null
      })(),
      "@order": "create_time-",
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => e.Crud),
  total: res.total
})', '1', 1718189065109, 1, 1718189065109, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (711, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Crud: req
})', 'res', '1', 1699979577844, 1, 1699979577844, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (712, '{
    "normal_text": "普通文本",
    "number-number": "数字",
    "select_box-select": "下拉框",
    "rich_text-editor": "富文本",
    "img-img": "图片地址",
    "file-file": "文件地址"
}', '{
    "img": {
        "type": "string",
        "required": true
    },
    "file": {
        "type": "string",
        "required": true
    },
    "number": {
        "type": "number",
        "required": true
    },
    "rich_text": {
        "type": "string",
        "required": true,
        "width":1200
    },
    "select_box": {
        "type": "string",
        "required": true,
        "select": [
            {
                "label": "是",
                "value": "1"
            },
            {
                "label": "否",
                "value": "0"
            }
        ]
    },
    "normal_text": {
        "type": "string",
        "required": true
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Crud: {
      ...req,
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720029241854, 1, 1720029241854, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (744, '{
  "id": "ID",
  "pid-select": "父id",
  "icon_img-img": "图标",
  "name": "名称",
  "sort-number": "排序",
  "is_hot-select": "是否热门"
}', '{
  "id": {
    "type": "number",
    "required": true
  },
  "pid": {
    "type": "number",
    "required": true,
    "select": "/course_category/roots/get"
  },
  "icon_img": {
    "type": "string",
    "required": "false"
  },
  "name": {
    "type": "string",
    "required": true
  },
  "sort": {
    "type": "number",
    "required": true
  },
  "is_hot": {
    "type": "boolean",
    "required": true,
    "select": [{
        "label": "是",
        "value": true
      },
      {
        "label": "否",
        "value": false
      }
    ]
  }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Course_category: {
      ...req,
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719219216360, 1, 1719219216360, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (745, '{}', '{}', '({
  "[]": {
    Course_category: {
      "@order": "sort+,create_time-",
    },
    "query": 2
  }
})', '(() => {
    let arr = []
    let list = res[''[]'']?.map(e => e.Course_category)||[];
    let roots = list.filter(e => {
        e[''is_hot-render''] = e.is_hot ? ''是'' : ''否''
        let flag = e.pid == 0;
        if (flag) {
            return true
        } else {
            arr.push(e)
            return false
        }
    });
    roots.forEach(e => {
        e.children = e.children || []
        for (let i = 0; i < arr.length; i++) {
            let o = arr[i]
            if (o.pid == e.id) {
                arr.splice(i, 1)
                e.children.push(o)
                i--
            }
        }
    })
    return {
        list: roots
    }
})()', '1', 1719221607907, 1, 1719221607907, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (746, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Course_category: req
})', 'res', '1', 1718759553477, 1, 1718759553477, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (747, '{
    "pid-select": "父id",
    "icon_img-img": "图标",
    "name": "名称",
    "sort-number": "排序",
    "is_hot-select": "是否热门"
}', '{
    "pid": {
        "type": "number",
        "required": true,
        "select": "/course_category/roots/get"
    },
    "icon_img": {
        "type": "string",
        "required": "false"
    },
    "name": {
        "type": "string",
        "required": true
    },
    "sort": {
        "type": "number",
        "required": true
    },
    "is_hot": {
        "type": "boolean",
        "required": true,
        "select": [
            {
                "label": "是",
                "value": true
            },
            {
                "label": "否",
                "value": false
            }
        ]
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Course_category: {
      ...req,
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719219170079, 1, 1719219170079, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (749, '{}', '{}', '({
  "[]": {
    Course_category: {
      "pid": 0,
      "@order": "sort+,create_time-",
      "@column": "id:value,name:label",
    },
    "query": 2
  }
})', '(() => {
  let data = res[''[]'']?.map(e => e.Course_category) || []
  return [{
    label: ''根级别'',
    value: 0
  }, ...data]
})()', '1', 1719218626458, 1, 1719218626458, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (750, 'null', 'null', NULL, NULL, '1', 1719221273625, 1, 1719221273625, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (751, '{
    "id": "主键",
    "name": "姓名",
    "img-img": "照片",
    "tag-select": "标签",
    "position-cascader": "职位",
    "intro-editor": "简介",
    "sort-number": "排序"
}', '{
    "id": {
        "type": "number",
        "required": 1
    },
    "name": {
        "type": "string",
        "required": 1,
        "formWidth": 1000
    },
    "img": {
        "type": "string",
        "required": 1
    },
    "sort": {
        "type": "number",
        "required": 1
    },
    "tag": {
        "type": "string",
        "required": "false",
        "select": "/teacher_tag/select/get",
        "multiple": true
    },
    "intro": {
        "type": "string",
        "required": 1
    },
    "position": {
        "type": "string",
        "required": true,
        "cascader": "/course_category/cascader/get"
    }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Teacher: {
      ...req,
      position_id: req.position.slice(-1)[0],
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720594725676, 1, 1720594725676, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (752, '{
    "name-text": "姓名",
    "position-cascader": "职位"
}', '{
    "name": {
        "type": "string",
        "required": false
    },
    "position": {
        "type": "string",
        "required": false,
        "multiple": false,
        "cascader": "/course_category/cascader/get"
    }
}', '({
  "[]": {
    Teacher: {
      "name~": !!req.name ? req.name : null,
      "position_id": (req.position || []).length > 0 ? req.position.slice(-1)[0] : null,
      "@order": "sort+,create_time-",
      "Teacher_tag[]": {
        Teacher_tag: {
          "id{}@": "[]/Teacher/tag",
          "@column": "name"
        },
      },
      Course_category: {
        "id@": "[]/Teacher/position_id",
        "@column": "name"
      }
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => {
    let item = e.Teacher
    item[''tag-render''] = item[''Teacher_tag[]''].map(o => o.name).join(",")
    item[''position-render''] = item[''Course_category''].name
    delete item[''Teacher_tag[]'']
    delete item[''Course_category'']
    return item
  }),
  total: res.total
})', '1', 1719512656405, 1, 1719512656405, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (753, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Teacher: req
})', 'res', '1', 1719215753837, 1, 1719215753837, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (754, '{
    "name": "姓名",
    "img-img": "照片",
    "tag-select": "标签",
    "position-cascader": "职位",
    "intro-editor": "简介",
    "sort-number": "排序"
}', '{
  "name": {
    "type": "string",
    "required": true,
    "formWidth": 1000
  },
  "img": {
    "type": "string",
    "required": true
  },
  "sort": {
    "type": "number",
    "required": true
  },
  "tag": {
    "type": "string",
    "required": false,
    "select": "/teacher_tag/select/get",
    "multiple": true
  },
  "intro": {
    "type": "string",
    "required": true
  },
  "position": {
    "type": "string",
    "required": true,
    "cascader": "/course_category/cascader/get"
  }
}', '(() => {
  let time = new Date().getTime()
  return {
    Teacher: {
      ...req,
      position_id: req.position.slice(-1)[0],
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720575571393, 1, 1720575571393, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (757, '{
    "id": "主键",
    "name": "名称"
}', '{
    "id": {
        "type": "number",
        "required": "true"
    },
    "name": {
        "type": "string",
        "required": "true"
    }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Teacher_tag: {
      ...req,
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719221313121, 1, 1719221313121, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (758, '{
  "name": "名称"
}', '{}', '({
  "[]": {
    Teacher_tag: {
      "name~": !!req.name ? req.name : null,
      "@order": "update_time-",
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => e.Teacher_tag),
  total: res.total
})', '1', 1719362943032, 1, 1719362943032, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (759, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Teacher_tag: req
})', 'res', '1', 1719221321829, 1, 1719221321829, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (760, '{
    "name": "名称"
}', '{
    "name": {
        "type": "string",
        "required": "true"
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Teacher_tag: {
      ...req,
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719221326014, 1, 1719221326014, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (761, '{}', '{}', '({
  "[]": {
    Teacher_tag: {
      "@order": "update_time-",
      "@column": "id:value,name:label",
    },
    "query": 2
  }
})', 'res[''[]'']?.map(e => {
  e.Teacher_tag.text = e.Teacher_tag.label
  return e.Teacher_tag
}) || []', '1', 1719504341864, 1, 1719504341864, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (762, '{}', '{}', '({
  "[]": {
    Course_category: {
      "@column": "id:value,pid,name:label",
      "@order": "sort+,create_time-",
    },
    "query": 2
  }
})', '(() => {
    let arr = []
    let list = res[''[]'']?.map(e => e.Course_category)||[];
    let roots = list.filter(e => {
        let flag = e.pid == 0;
        if (flag) {
            return true
        } else {
            arr.push(e)
            return false
        }
    });
    roots.forEach(e => {
        e.children = e.children || []
        for (let i = 0; i < arr.length; i++) {
            let o = arr[i]
            if (o.pid == e.value) {
                arr.splice(i, 1)
                e.children.push(o)
                i--
            }
        }
    })
    return roots
})()', '1', 1719301386127, 1, 1719301386127, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (765, '{
  "id": "主键",
  "name": "名称",
  "position-cascader": "职位",
  "img-img": "封面",
  "file-file": "文件",
  "sort-number": "排序",
}', '{
    "id": {
        "type": "number",
        "required": "true"
    },
    "img": {
        "type": "string",
        "required": "true"
    },
    "file": {
        "type": "string",
        "required": "true"
    },
    "name": {
        "type": "string",
        "required": "true"
    },
    "sort": {
        "type": "number",
        "required": "true"
    },
    "position": {
        "type": "number",
        "required": "true",
        "cascader": "/course_category/cascader/get"
    }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Material: {
      ...req,
      position_id: req.position.slice(-1)[0],
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719361465065, 1, 1719361465065, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (766, '{
    "name": "名称",
    "position-cascader": "职位"
}', '{
    "name": {
        "type": "string",
        "required": false
    },
    "position": {
        "type": "string",
        "required": false,
        "multiple": false,
        "cascader": "/course_category/cascader/get"
    }
}', '({
  "[]": {
    Material: {
      "name~": !!req.name ? req.name : null,
      "position_id": (req.position || []).length > 0 ? req.position.slice(-1)[0] : null,
      "@order": "sort+,create_time-",
      Course_category: {
        "id@": "[]/Material/position_id",
        "@column": "name"
      }
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => {
    let item = e.Material
    item[''position-render''] = item[''Course_category''].name
    delete item[''Course_category'']
    return item
  }),
  total: res.total
})', '1', 1719512776940, 1, 1719512776940, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (767, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Material: req
})', 'res', '1', 1719361332221, 1, 1719361332221, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (768, '{
  "name": "名称",
  "position-cascader": "职位",
  "img-img": "封面",
  "file-file": "文件",
  "sort-number": "排序",
}', '{
    "img": {
        "type": "string",
        "required": "true"
    },
    "file": {
        "type": "string",
        "required": "true"
    },
    "name": {
        "type": "string",
        "required": "true"
    },
    "sort": {
        "type": "number",
        "required": "true"
    },
    "position": {
        "type": "number",
        "required": "true",
        "cascader": "/course_category/cascader/get"
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Material: {
      ...req,
      position_id: req.position.slice(-1)[0],
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719361473184, 1, 1719361473184, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (770, '{
    "id": "主键",
    "name": "名称",
    "position-cascader": "职位",
    "img-img": "封面",
    "file-file": "文件",
    "sort-number": "排序"
}', '{
    "id": {
        "type": "number",
        "required": "true"
    },
    "img": {
        "type": "string",
        "required": "true"
    },
    "file": {
        "type": "string",
        "required": "true"
    },
    "name": {
        "type": "string",
        "required": "true"
    },
    "sort": {
        "type": "number",
        "required": "true"
    },
    "position": {
        "type": "number",
        "required": "true",
        "cascader": "/course_category/cascader/get"
    }
}', '(() => {
  let nulls = [];
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Library: {
      ...req,
      position_id: req.position.slice(-1)[0],
      "@null": nulls.join(","),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719362319873, 1, 1719362319873, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (771, '{
    "name": "名称",
    "position-cascader": "职位"
}', '{
    "name": {
        "type": "string",
        "required": false
    },
    "position": {
        "type": "string",
        "required": false,
        "multiple": false,
        "cascader": "/course_category/cascader/get"
    }
}', '({
  "[]": {
    Library: {
      "name~": !!req.name ? req.name : null,
      "position_id": (req.position || []).length > 0 ? req.position.slice(-1)[0] : null,
      "@order": "sort+,create_time-",
      Course_category: {
        "id@": "[]/Library/position_id",
        "@column": "name"
      }
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => {
    let item = e.Library
    item[''position-render''] = item[''Course_category''].name
    delete item[''Course_category'']
    return item
  }),
  total: res.total
})', '1', 1719512769779, 1, 1719512769779, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (772, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Library: req
})', 'res', '1', 1719362303186, 1, 1719362303186, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (773, '{
    "name": "名称",
    "position-cascader": "职位",
    "img-img": "封面",
    "file-file": "文件",
    "sort-number": "排序"
}', '{
    "img": {
        "type": "string",
        "required": "true"
    },
    "file": {
        "type": "string",
        "required": "true"
    },
    "name": {
        "type": "string",
        "required": "true"
    },
    "sort": {
        "type": "number",
        "required": "true"
    },
    "position": {
        "type": "number",
        "required": "true",
        "cascader": "/course_category/cascader/get"
    }
}', '(() => {
  let time = new Date().getTime()
  return {
    Library: {
      ...req,
      position_id: req.position.slice(-1)[0],
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1719362298894, 1, 1719362298894, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (775, '{
    "id": "优惠卷ID",
    "name": "名称",
    "quantity-number": "数量",
    "start_time-date": "开始时间",
    "end_time-date": "结束时间",
    "amount_full-number": "满额",
    "amount_reduce-number": "减额",
    "specified_product-switch": "指定商品卷",
    "designated_products": "指定商品",
    "on_shelf-switch": "上架",
    "sort-number": "排序"
}', '{
    "id": {
        "type": "number",
        "required": 1
    },
    "name": {
        "type": "string",
        "required": 1,
        "formWidth": 700
    },
    "sort": {
        "type": "number",
        "required": 1
    },
    "end_time": {
        "type": "number",
        "required": 1
    },
    "on_shelf": {
        "type": "boolean",
        "required": 1
    },
    "quantity": {
        "type": "number",
        "required": 1
    },
    "start_time": {
        "type": "number",
        "required": 1
    },
    "amount_full": {
        "type": "number",
        "required": 1
    },
    "amount_reduce": {
        "type": "number",
        "required": 1
    },
    "received_quantity": {
        "type": "number",
        "required": 1
    },
    "specified_product": {
        "type": "boolean",
        "required": 1
    },
    "designated_products": {
        "type": "string",
        "required": 0
    }
}', '(() => {
  let nulls = [];
  let {
    start_time,
    end_time
  } = req
  delete req.start_time
  delete req.end_time
  for (let key in req)
    if (req[key] === null) nulls.push(key)
  return {
    Coupon: {
      ...req,
      "@null": nulls.join(","),
      start_time: moment(start_time).startOf(''day'').valueOf(),
      end_time: moment(end_time).endOf(''day'').valueOf(),
      update_time: new Date().getTime(),
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720595506660, 1, 1720595506660, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (776, '{
    "pageIndex": "页码",
    "pageSize": "一页条数"
}', '{
    "pageIndex": {
        "required": false,
        "type": "number"
    },
    "pageSize": {
        "required": false,
        "type": "number"
    }
}', '({
  "[]": {
    Coupon: {
      "@order": "sort+,create_time-",
    },
    "query": 2,
    "page": (req.pageIndex || 1) - 1,
    "count": req.pageSize || 10
  },
  "total@": "/[]/total"
})', '({
  list: res[''[]'']?.map(e => {
    let item = e.Coupon
    item[''on_shelf-render''] = item.on_shelf ? "<a style=''color:green''>已上架</a>" : "<a style=''color:red''>未上架</a>"
    item[''specified_product-render''] = item.specified_product ? "商品卷" : "通用卷"
    return item;
  }),
  total: res.total
})', '1', 1720595601788, 1, 1720595601788, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (777, '{
    "id": "主键id"
}', '{
    "id": {
        "type": "number",
        "required": true
    }
}', '({
  Coupon: req
})', 'res', '1', 1720516111903, 1, 1720516111903, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (778, '{
    "name": "名称",
    "quantity-number": "数量",
    "start_time-date": "开始时间",
    "end_time-date": "结束时间",
    "amount_full-number": "满额",
    "amount_reduce-number": "减额",
    "specified_product-switch": "指定商品卷",
    "designated_products": "指定商品",
    "on_shelf-switch": "上架",
    "sort-number": "排序"
}', '{
    "name": {
        "type": "string",
        "required": 1,
        "formWidth": 700
    },
    "sort": {
        "type": "number",
        "required": 1
    },
    "end_time": {
        "type": "number",
        "required": 1
    },
    "on_shelf": {
        "type": "boolean",
        "required": 1
    },
    "quantity": {
        "type": "number",
        "required": 1
    },
    "start_time": {
        "type": "number",
        "required": 1
    },
    "amount_full": {
        "type": "number",
        "required": 1
    },
    "amount_reduce": {
        "type": "number",
        "required": 1
    },
    "specified_product": {
        "type": "boolean",
        "required": 1
    },
    "designated_products": {
        "type": "string",
        "required": 0
    }
}', '(() => {
  let time = new Date().getTime()
  let {
    start_time,
    end_time
  } = req
  delete req.start_time
  delete req.end_time
  return {
    Coupon: {
      ...req,
      start_time: moment(start_time).startOf(''day'').valueOf(),
      end_time: moment(end_time).endOf(''day'').valueOf(),
      create_time: time,
      create_user_id: system.id,
      update_time: time,
      update_user_id: system.id
    }
  }
})()', 'res', '1', 1720595489461, 1, 1720595489461, 1);
INSERT INTO "public"."low_code_permission" ("permission_id", "param", "param_valid", "json", "response", "status",
                                            "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (779, '{}', '{}', '({
  Crud: {
    id: 1,
    ''number+'':1
  }
})', 'res', '1', 1720766609925, 1, 1720766609925, 1);
COMMIT;

-- ----------------------------
-- Table structure for material
-- ----------------------------
DROP TABLE IF EXISTS "public"."material";
CREATE TABLE "public"."material"
(
    "id"             int8                                        NOT NULL,
    "position"       text COLLATE "pg_catalog"."default"         NOT NULL,
    "position_id"    int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "img"            varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "file"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "sort"           int4                                        NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."material" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."material"."id" IS '主键';
COMMENT
ON COLUMN "public"."material"."position" IS '职位';
COMMENT
ON COLUMN "public"."material"."position_id" IS '职位id|';
COMMENT
ON COLUMN "public"."material"."name" IS '名称';
COMMENT
ON COLUMN "public"."material"."img" IS '封面';
COMMENT
ON COLUMN "public"."material"."file" IS '文件';
COMMENT
ON COLUMN "public"."material"."sort" IS '排序';
COMMENT
ON COLUMN "public"."material"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."material"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."material"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."material"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."material" IS '考试资料';

-- ----------------------------
-- Records of material
-- ----------------------------
BEGIN;
INSERT INTO "public"."material" ("id", "position", "position_id", "name", "img", "file", "sort", "create_time",
                                 "create_user_id", "update_time", "update_user_id")
VALUES (1, '[71, 72]', 72, '初级会计《实务》100个卡片考点.pdf', 'file/download/1/1720017097739/下载 (1).png',
        'file/download/1/1720017104396/初级会计《实务》100个卡片考点.pdf', 1, 1719361746727, 1, 1720017105533, 1);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS "public"."menu";
CREATE TABLE "public"."menu"
(
    "id"             int8                                        NOT NULL,
    "pid"            int8                                        NOT NULL,
    "title"          varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "path"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "component"      varchar(255) COLLATE "pg_catalog"."default",
    "sort"           int4,
    "status"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."menu" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."menu"."id" IS 'id';
COMMENT
ON COLUMN "public"."menu"."pid" IS '父id';
COMMENT
ON COLUMN "public"."menu"."title" IS '路由地址';
COMMENT
ON COLUMN "public"."menu"."name" IS '菜单';
COMMENT
ON COLUMN "public"."menu"."path" IS '组件路径';
COMMENT
ON COLUMN "public"."menu"."component" IS '组件路径';
COMMENT
ON COLUMN "public"."menu"."sort" IS '排序号';
COMMENT
ON COLUMN "public"."menu"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."menu"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."menu"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."menu"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."menu"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."menu" IS '菜单表';

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (2, 0, '平台用户管理', 'user_manager', '/user_manager', '/page/user_manager', 5, '1', 0, 0, 1691044219222, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (3, 0, '开发者菜单管理', 'menu_manager', '/menu_manager', '/page/menu_manager', 2, '1', 0, 0, 1691044219220, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (4, 0, '用户角色管理', 'role_manager', '/role_manager', '/page/role_manager', 3, '1', 0, 0, 1691044219220, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (29, 0, '接口管理', 'interface_manager', '/interface_manager', '/page/interface_manager', 0, '1', 1681126774304,
        1, 1691044219218, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (31, 0, '模块菜单管理', 'module_manager', '/module_manager', '/page/module_manager', 4, '1', 1681140612409, 1,
        1691044219221, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (34, 0, '数据表管理', 'data_manager', '/data_manager', '/page/data_manager', 1, '1', 1686151587704, 1,
        1691044219219, 1);
INSERT INTO "public"."menu" ("id", "pid", "title", "name", "path", "component", "sort", "status", "create_time",
                             "create_user_id", "update_time", "update_user_id")
VALUES (35, 0, '定时任务管理', 'cron_manager', '/cron_manager', '/page/cron_manager', 6, '1', 1691043960059, 1,
        1691044219222, 1);
COMMIT;

-- ----------------------------
-- Table structure for module
-- ----------------------------
DROP TABLE IF EXISTS "public"."module";
CREATE TABLE "public"."module"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "pid"            int8                                        NOT NULL,
    "tag"            varchar(32) COLLATE "pg_catalog"."default"  NOT NULL,
    "path"           varchar(255) COLLATE "pg_catalog"."default",
    "component"      varchar(500) COLLATE "pg_catalog"."default",
    "meta"           text COLLATE "pg_catalog"."default",
    "sort"           int4,
    "status"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."module" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."module"."id" IS 'id';
COMMENT
ON COLUMN "public"."module"."name" IS '模块名';
COMMENT
ON COLUMN "public"."module"."pid" IS '父id';
COMMENT
ON COLUMN "public"."module"."tag" IS '模块标志';
COMMENT
ON COLUMN "public"."module"."path" IS 'url路径';
COMMENT
ON COLUMN "public"."module"."component" IS '组件路径';
COMMENT
ON COLUMN "public"."module"."meta" IS '拓展信息';
COMMENT
ON COLUMN "public"."module"."sort" IS '排序号';
COMMENT
ON COLUMN "public"."module"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."module"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."module"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."module"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."module"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."module" IS '模块管理';

-- ----------------------------
-- Records of module
-- ----------------------------
BEGIN;
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (1, '管理端', 0, 'PC', NULL, NULL, NULL, NULL, '1', 0, 0, 0, 0);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (2, '公众号', 0, 'H5', NULL, NULL, NULL, NULL, '1', 0, 0, 0, 0);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (3, '浏览器', 0, 'WEB', NULL, NULL, NULL, NULL, '1', 0, 0, 0, 0);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (4, '小程序', 0, 'WX', NULL, NULL, NULL, NULL, '1', 0, 0, 0, 0);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (8, 'banner管理', 1, 'PC', '/layout/banner', '/crud/index', '[''banner'']', 999, '1', 1699193508769, 1,
        1719214883179, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (12, '模板管理', 1, 'PC', '/layout/crud', '/crud/index', '[''crud'']', 999, '1', 1699979132834, 1, 1719214889521,
        1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (13, '课程分类', 1, 'PC', '/layout/course_category', '/crud/index', '[''course_category'']', 1, '1',
        1718759500134, 1, 1719394478852, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (14, '师资团队', 1, 'PC', '/layout/teacher', '/crud/index', '[''teacher'']', 3, '1', 1719215375850, 1,
        1719394485581, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (17, '师资标签', 1, 'PC', '/layout/teacher_tag', '/crud/index', '[''teacher_tag'']', 2, '1', 1719221022631, 1,
        1719394482023, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (18, '报考指南', 1, 'PC', '/layout/guide', '/crud/index', '[''guide'']', 4, '1', 1719306485941, 1, 1719394488779,
        1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (19, '考试资料', 1, 'PC', '/layout/material', '/crud/index', '[''material'']', 5, '1', 1719307494384, 1,
        1719394491788, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (20, '相关题库', 1, 'PC', '/layout/library', '/crud/index', '[''library'']', 6, '1', 1719362151914, 1,
        1719394501836, 1);
INSERT INTO "public"."module" ("id", "name", "pid", "tag", "path", "component", "meta", "sort", "status", "create_time",
                               "create_user_id", "update_time", "update_user_id")
VALUES (21, '优惠卷', 1, 'PC', '/layout/coupon', '/crud/index', '[''coupon'']', 7, '1', 1720515997830, 1, 1720515997830,
        1);
COMMIT;

-- ----------------------------
-- Table structure for module_permission
-- ----------------------------
DROP TABLE IF EXISTS "public"."module_permission";
CREATE TABLE "public"."module_permission"
(
    "module_id"     int8 NOT NULL,
    "permission_id" int8 NOT NULL
)
;
ALTER TABLE "public"."module_permission" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."module_permission"."module_id" IS '模块id';
COMMENT
ON COLUMN "public"."module_permission"."permission_id" IS '权限id';
COMMENT
ON TABLE "public"."module_permission" IS '模块权限关系表';

-- ----------------------------
-- Records of module_permission
-- ----------------------------
BEGIN;
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (8, 687);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (8, 688);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (8, 689);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (8, 690);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (8, 691);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 708);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 708);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 708);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 709);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 709);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 709);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 709);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 710);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 710);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 710);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 710);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 711);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 711);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 711);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 711);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 712);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 712);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 712);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (12, 712);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 743);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 743);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 744);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 744);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 745);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 745);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 746);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 746);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 747);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 747);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (13, 749);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (14, 750);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (14, 751);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (14, 752);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (14, 753);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (14, 754);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (17, 756);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (17, 757);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (17, 758);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (17, 759);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (17, 760);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (19, 764);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (19, 765);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (19, 766);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (19, 767);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (19, 768);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (20, 769);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (20, 770);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (20, 771);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (20, 772);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (20, 773);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (21, 774);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (21, 775);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (21, 776);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (21, 777);
INSERT INTO "public"."module_permission" ("module_id", "permission_id")
VALUES (21, 778);
COMMIT;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS "public"."permission";
CREATE TABLE "public"."permission"
(
    "id"             int8                                        NOT NULL,
    "url"            varchar(500) COLLATE "pg_catalog"."default" NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "pid"            int8                                        NOT NULL,
    "is_low_code"    varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "controller"     varchar(500) COLLATE "pg_catalog"."default",
    "method"         varchar(100) COLLATE "pg_catalog"."default",
    "open"           varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "authentication" varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "auto_test"      varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "test_result"    varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "mock_time"      int8,
    "status"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."permission" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."permission"."id" IS '主键id';
COMMENT
ON COLUMN "public"."permission"."url" IS '接口路径';
COMMENT
ON COLUMN "public"."permission"."name" IS '接口名字/组名字';
COMMENT
ON COLUMN "public"."permission"."pid" IS '父id';
COMMENT
ON COLUMN "public"."permission"."is_low_code" IS '是否低代码';
COMMENT
ON COLUMN "public"."permission"."controller" IS '接口类名';
COMMENT
ON COLUMN "public"."permission"."method" IS '接口方法名';
COMMENT
ON COLUMN "public"."permission"."open" IS '是否开放';
COMMENT
ON COLUMN "public"."permission"."authentication" IS '是否鉴权';
COMMENT
ON COLUMN "public"."permission"."auto_test" IS '是否执行自动化mock测试';
COMMENT
ON COLUMN "public"."permission"."test_result" IS '测试结果';
COMMENT
ON COLUMN "public"."permission"."mock_time" IS '测试时间';
COMMENT
ON COLUMN "public"."permission"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."permission"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."permission"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."permission"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."permission"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."permission" IS '权限表';

-- ----------------------------
-- Records of permission
-- ----------------------------
BEGIN;
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (603, 'pt/sql', 'SQL管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0, 1690910152301,
        0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (604, 'pt/permission', '接口管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0,
        1690910152301, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (605, 'pt/permissionRule', '权限规则管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0,
        1690910152301, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (606, 'pt/file', '文件相关接口', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0,
        1690910152301, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (607, 'pt/user', '用户管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0, 1690910152301,
        0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (608, 'pt/table', '数据表管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0,
        1690910152301, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (609, 'pt/role', '角色管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0, 1690910152301,
        0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (610, 'pt/menu', '菜单管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0, 1690910152301,
        0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (611, 'pt/module', '模块管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1690910152301, 0,
        1690910152301, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (612, 'pt/permission/all', '获取所有接口树', 604, '0', 'pr.lanmu.controller.PermissionController', 'all', '0',
        '0', '0', '1', 1690943939816, '1', 1690910152324, 0, 1720753508666, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (613, 'pt/sql/execute', '执行sql', 603, '0', 'pr.lanmu.controller.SQLController', 'execute', '0', '0', '0', '0',
        NULL, '1', 1690910152324, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (614, 'pt/permission/config', '接口配置信息一键使用默认值', 604, '0', 'pr.lanmu.controller.PermissionController',
        'config', '0', '0', '0', '0', NULL, '1', 1690910152324, 0, 1720753508669, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (615, 'pt/permission/del', '删除低代码接口', 604, '0', 'pr.lanmu.controller.PermissionController', 'del', '0',
        '0', '0', '0', NULL, '1', 1690910152324, 0, 1720753508666, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (616, 'pt/permission/saveAndBingModule', '创建低代码接口并绑定模块', 604, '0',
        'pr.lanmu.controller.PermissionController', 'saveAndBingModule', '0', '0', '0', '0', NULL, '1', 1690910152324,
        0, 1720753508669, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (617, 'pt/permission/saveTestResult', '保存接口测试结果', 604, '0', 'pr.lanmu.controller.PermissionController',
        'saveTestResult', '0', '0', '0', '0', NULL, '1', 1690910152324, 0, 1720753508657, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (618, 'pt/permission/setAutoTest', '设置是否开启自动化测试', 604, '0',
        'pr.lanmu.controller.PermissionController', 'setAutoTest', '0', '0', '0', '0', NULL, '1', 1690910152324, 0,
        1720753508666, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (619, 'pt/permission/saveRule', '保存mock规则', 604, '0', 'pr.lanmu.controller.PermissionController', 'saveRule',
        '0', '0', '0', '0', NULL, '1', 1690910152324, 0, 1720753508625, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (620, 'pt/permission/save', '保存低代码接口', 604, '0', 'pr.lanmu.controller.PermissionController', 'save', '0',
        '0', '0', '0', NULL, '1', 1690910152324, 0, 1720753508655, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (621, 'pt/permissionRule/get', '获取权限规则', 605, '0', 'pr.lanmu.controller.PermissionRuleController', 'get',
        '0', '0', '0', '0', NULL, '1', 1690910152325, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (622, 'pt/file/upload', '文件上传', 606, '0', 'pr.lanmu.controller.FileController', 'upload', '0', '0', '0', '0',
        NULL, '1', 1690910152327, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (623, 'pt/user/setRole', '设置用户角色', 607, '0', 'pr.lanmu.controller.UserController', 'setRole', '0', '0',
        '0', '0', NULL, '1', 1690910152328, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (624, 'pt/table/list', '查询数据表信息', 608, '0', 'pr.lanmu.controller.TableController', 'list', '0', '0', '0',
        '0', NULL, '1', 1690910152330, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (625, 'pt/role/del', '删除角色', 609, '0', 'pr.lanmu.controller.RoleController', 'del', '0', '0', '0', '0', NULL,
        '1', 1690910152331, 0, 1720753508615, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (626, 'pt/menu/del', '删除菜单', 610, '0', 'pr.lanmu.controller.MenuController', 'del', '0', '0', '0', '0', NULL,
        '1', 1690910152333, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (627, 'pt/module/all', '获取所有模块树', 611, '0', 'pr.lanmu.controller.ModuleController', 'all', '0', '0', '0',
        '1', 1698864966939, '1', 1690910152334, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (628, 'pt/menu/all', '获取全部菜单', 610, '0', 'pr.lanmu.controller.MenuController', 'all', '0', '0', '0', '0',
        NULL, '1', 1690910152336, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (629, 'pt/permission/copyDir', '接口目录复制', 604, '0', 'pr.lanmu.controller.PermissionController', 'copyDir',
        '0', '0', '0', '0', NULL, '1', 1690910152337, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (630, 'pt/role/save', '保存角色', 609, '0', 'pr.lanmu.controller.RoleController', 'save', '0', '0', '0', '0',
        NULL, '1', 1690910152338, 0, 1720753508635, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (631, 'pt/role/list', '分页查询角色', 609, '0', 'pr.lanmu.controller.RoleController', 'list', '0', '0', '0', '0',
        NULL, '1', 1690910152340, 0, 1720753508631, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (632, 'pt/user/module', '获取登录用户业务模块', 607, '0', 'pr.lanmu.controller.UserController', 'module', '0',
        '0', '0', '0', NULL, '1', 1690910152342, 0, 1720753508639, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (633, 'pt/module/save', '保存模块', 611, '0', 'pr.lanmu.controller.ModuleController', 'save', '0', '0', '0', '0',
        NULL, '1', 1690910152346, 0, 1720753508655, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (634, 'pt/user/list', '分页查询用户', 607, '0', 'pr.lanmu.controller.UserController', 'list', '0', '0', '0', '0',
        NULL, '1', 1690910152347, 0, 1720753508615, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (635, 'pt/role/setModule', '设置模块权限', 609, '0', 'pr.lanmu.controller.RoleController', 'setModule', '0', '0',
        '0', '0', NULL, '1', 1690910152349, 0, 1720753508631, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (636, 'pt/menu/save', '保存菜单', 610, '0', 'pr.lanmu.controller.MenuController', 'save', '0', '0', '0', '0',
        NULL, '1', 1690910152348, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (637, 'pt/menu/setSort', '菜单重排序', 610, '0', 'pr.lanmu.controller.MenuController', 'setSort', '0', '0', '0',
        '0', NULL, '1', 1690910152350, 0, 1720753508605, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (638, 'pt/user/setPassword', '设置用户密码', 607, '0', 'pr.lanmu.controller.UserController', 'setPassword', '0',
        '0', '0', '0', NULL, '1', 1690910152351, 0, 1720753508629, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (639, 'pt/user/menu', '获取登录用户开发者菜单', 607, '0', 'pr.lanmu.controller.UserController', 'menu', '0', '0',
        '0', '0', NULL, '1', 1690910152352, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (640, 'pt/role/setMenu', '设置角色菜单', 609, '0', 'pr.lanmu.controller.RoleController', 'setMenu', '0', '0',
        '0', '0', NULL, '1', 1690910152353, 0, 1720753508639, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (641, 'pt/module/del', '删除模块', 611, '0', 'pr.lanmu.controller.ModuleController', 'del', '0', '0', '0', '0',
        NULL, '1', 1690910152356, 0, 1720753508647, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (642, 'pt/module/permission', '绑定接口权限', 611, '0', 'pr.lanmu.controller.ModuleController', 'permission',
        '0', '0', '0', '0', NULL, '1', 1690910152357, 0, 1720753508650, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (643, 'pt/user/del', '删除用户', 607, '0', 'pr.lanmu.controller.UserController', 'del', '0', '0', '0', '0', NULL,
        '1', 1690910152358, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (644, 'pt/role/all', '全部角色', 609, '0', 'pr.lanmu.controller.RoleController', 'all', '0', '0', '0', '0', NULL,
        '1', 1690910152358, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (645, 'pt/user/changePassword', '修改自己密码', 607, '0', 'pr.lanmu.controller.UserController', 'changePassword',
        '0', '0', '0', '0', NULL, '1', 1690910152358, 0, 1720753508625, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (646, 'pt/module/roots', '获取全部平台', 611, '0', 'pr.lanmu.controller.ModuleController', 'roots', '0', '0',
        '0', '1', 1698864909693, '1', 1690910152361, 0, 1720753508610, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (647, 'pt/user/add', '新增用户', 607, '0', 'pr.lanmu.controller.UserController', 'add', '0', '0', '0', '0', NULL,
        '1', 1690910152361, 0, 1720753508625, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (648, 'pt/module/root', '获取指定平台模块树', 611, '0', 'pr.lanmu.controller.ModuleController', 'root', '0', '0',
        '0', '1', 1698890339032, '1', 1690910152361, 0, 1720753508643, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (649, 'pt/user/login', '登录', 607, '0', 'pr.lanmu.controller.UserController', 'login', '1', '0', '0', '0', NULL,
        '1', 1690910152364, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (651, 'pt/user/userInfo', '获取用户信息', 607, '0', 'pr.lanmu.controller.UserController', 'userInfo', '0', '0',
        '0', '1', 1691138586626, '1', 1690910904019, 0, 1720753508639, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (661, 'pt/fzmb', '复杂模板', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1691042599657, 1, 1699011949215,
        1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (662, 'pt/fzmb/get', '关联查询', 661, '1', NULL, NULL, '0', '0', '0', '1', 1691347315945, '1', 1691042689455, 1,
        1691042689455, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (663, 'pt/fzmb/post', '多种操作', 661, '1', NULL, NULL, '0', '0', '0', '1', 1691043729117, '1', 1691043283767, 1,
        1691043725110, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (664, 'pt/cron', '定时任务管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1691045394046, 0,
        1691045394046, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (667, 'pt/cron/delete', '删除定时任务', 664, '0', 'pr.lanmu.controller.CronController', 'delete', '0', '0', '0',
        '0', NULL, '1', 1691046868304, 0, 1720753508604, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (668, 'pt/cron/list', '分页查询定时任务', 664, '0', 'pr.lanmu.controller.CronController', 'list', '0', '0', '0',
        '0', NULL, '1', 1691046868341, 0, 1720753508655, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (669, 'pt/cron/put', '修改定时任务', 664, '0', 'pr.lanmu.controller.CronController', 'put', '0', '0', '0', '0',
        NULL, '1', 1691046868345, 0, 1720753508661, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (670, 'pt/cron/post', '新增定时任务', 664, '0', 'pr.lanmu.controller.CronController', 'post', '0', '0', '0', '0',
        NULL, '1', 1691046868349, 0, 1720753508669, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (671, 'pt/task', '任务调度管理', 0, '0', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1691091128679, 0,
        1691091128679, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (672, 'pt/task/deleteTempFile', '定期清除临时过期文件夹', 671, '0', 'pr.lanmu.controller.TaskController',
        'deleteTempFile', '0', '0', '0', '1', 1691388586994, '1', 1691091128741, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (685, 'pt/fzmb/addOneByOneId/post', '关联新增', 661, '1', NULL, NULL, '0', '0', '0', '1', 1694437844403, '1',
        1694435380463, 1, 1694437822677, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (686, 'pt/permission/list', '获取所有接口', 604, '0', 'pr.lanmu.controller.PermissionController', 'list', '0',
        '0', '0', '1', 1698892099762, '1', 1698891292310, 0, 1720753508679, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (687, 'pt/banner', 'banner管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1699011370668, 1,
        1699372819977, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (688, 'pt/banner/put', '修改', 687, '1', NULL, NULL, '0', '0', '0', '1', 1699011683113, '1', 1699011370674, 1,
        1720596553362, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (689, 'pt/banner/get', '列表', 687, '1', NULL, NULL, '0', '0', '0', '1', 1699409215829, '1', 1699011370681, 1,
        1699372641822, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (690, 'pt/banner/delete', '删除', 687, '1', NULL, NULL, '0', '0', '0', '1', 1699011583013, '1', 1699011370684, 1,
        1699011418872, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (691, 'pt/banner/post', '新增', 687, '1', NULL, NULL, '0', '0', '0', '1', 1699409206818, '1', 1699011370689, 1,
        1720596458506, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (692, 'pt/module/getModuleTableInfo', '查询模块绑定的表和关联的接口及接口的校验规则', 611, '0',
        'pr.lanmu.controller.ModuleController', 'getModuleTableInfo', '0', '0', '0', '1', 1699193002634, '1',
        1699154144805, 0, 1720753508645, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (708, 'pt/crud', '增删改查', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1699422494651, 1, 1699422494651,
        1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (709, 'pt/crud/put', '修改', 708, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1699422494653, 1,
        1720029222323, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (710, 'pt/crud/get', '列表', 708, '1', NULL, NULL, '0', '0', '0', '1', 1712045024065, '1', 1699422494657, 1,
        1718189065093, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (711, 'pt/crud/delete', '删除', 708, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1', 1699422494662, 1,
        1699979577842, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (712, 'pt/crud/post', '新增', 708, '1', NULL, NULL, '0', '0', '0', '1', 1712120393480, '1', 1699422494667, 1,
        1720029241851, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (718, 'pt/task/autoCodeTest', '自动化测试', 671, '0', 'pr.lanmu.controller.TaskController', 'autoCodeTest', '0',
        '0', '0', '0', NULL, '1', 1699984303043, 0, 1720753508581, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (719, 'pt/cron/loads', '已装载定时任务', 664, '0', 'pr.lanmu.controller.CronController', 'loads', '0', '0', '0',
        '0', NULL, '1', 1712044977641, 0, 1720753508645, 0);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (743, 'pt/course_category', '课程分类管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1718759537558, 1,
        1718759537558, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (744, 'pt/course_category/put', '修改', 743, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1',
        1718759537564, 1, 1719219216357, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (745, 'pt/course_category/get', '列表', 743, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1',
        1718759537582, 1, 1719221607905, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (746, 'pt/course_category/delete', '删除', 743, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1',
        1718759537587, 1, 1718759553475, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (747, 'pt/course_category/post', '新增', 743, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1',
        1718759537592, 1, 1719219170077, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (749, 'pt/course_category/roots/get', '根级列表', 743, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1',
        1718766974431, 1, 1719218626455, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (750, 'pt/teacher', '师资团队管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1719215514187, 1,
        1719221273621, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (751, 'pt/teacher/put', '修改', 750, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1719215514189, 1,
        1720594725674, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (752, 'pt/teacher/get', '列表', 750, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1', 1719215514208, 1,
        1719512656397, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (753, 'pt/teacher/delete', '删除', 750, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1', 1719215514211,
        1, 1719215753835, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (754, 'pt/teacher/post', '新增', 750, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1', 1719215514214, 1,
        1720575571391, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (756, 'pt/teacher_tag', '师资标签管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1719221261398, 1,
        1719221261398, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (757, 'pt/teacher_tag/put', '修改', 756, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1719221261404,
        1, 1719221313117, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (758, 'pt/teacher_tag/get', '列表', 756, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1', 1719221261414,
        1, 1719362943030, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (759, 'pt/teacher_tag/delete', '删除', 756, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1',
        1719221261419, 1, 1719221321827, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (760, 'pt/teacher_tag/post', '新增', 756, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1', 1719221261426,
        1, 1719221326011, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (761, 'pt/teacher_tag/select/get', '下拉列表', 756, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1',
        1719221937365, 1, 1719504341850, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (762, 'pt/course_category/cascader/get', '级联选择', 743, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1',
        1719301183176, 1, 1719301386125, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (764, 'pt/material', '考试资料管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1719307946358, 1,
        1719307946358, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (765, 'pt/material/put', '修改', 764, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1719307946372, 1,
        1719361465062, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (766, 'pt/material/get', '列表', 764, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1', 1719307946403, 1,
        1719512776929, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (767, 'pt/material/delete', '删除', 764, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1', 1719307946414,
        1, 1719361332218, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (768, 'pt/material/post', '新增', 764, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1', 1719307946433, 1,
        1719361473181, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (769, 'pt/library', '相关题库管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1719362171831, 1,
        1719362171831, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (770, 'pt/library/put', '修改', 769, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1719362171834, 1,
        1719362319871, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (771, 'pt/library/get', '列表', 769, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1', 1719362171841, 1,
        1719512769775, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (772, 'pt/library/delete', '删除', 769, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1', 1719362171846,
        1, 1719362303184, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (773, 'pt/library/post', '新增', 769, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1', 1719362171851, 1,
        1719362298891, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (774, 'pt/coupon', '优惠卷管理', 0, '1', NULL, NULL, '0', '0', '0', '0', NULL, '1', 1720516039896, 1,
        1720516039896, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (775, 'pt/coupon/put', '修改', 774, '1', NULL, NULL, '0', '0', '0', '0', 1699011683113, '1', 1720516039897, 1,
        1720595506656, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (776, 'pt/coupon/get', '列表', 774, '1', NULL, NULL, '0', '0', '0', '0', 1712045024065, '1', 1720516039905, 1,
        1720595601787, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (777, 'pt/coupon/delete', '删除', 774, '1', NULL, NULL, '0', '0', '0', '0', 1699011583013, '1', 1720516039909, 1,
        1720516111899, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (778, 'pt/coupon/post', '新增', 774, '1', NULL, NULL, '0', '0', '0', '0', 1712120393480, '1', 1720516039912, 1,
        1720595489458, 1);
INSERT INTO "public"."permission" ("id", "url", "name", "pid", "is_low_code", "controller", "method", "open",
                                   "authentication", "auto_test", "test_result", "mock_time", "status", "create_time",
                                   "create_user_id", "update_time", "update_user_id")
VALUES (779, 'pt/fzmb/zizeng/put', '字段自增', 661, '1', NULL, NULL, '0', '0', '0', '1', 1720766541307, '1',
        1720750670815, 1, 1720766609924, 1);
COMMIT;

-- ----------------------------
-- Table structure for permission_mock_rule
-- ----------------------------
DROP TABLE IF EXISTS "public"."permission_mock_rule";
CREATE TABLE "public"."permission_mock_rule"
(
    "id"             int8                                      NOT NULL,
    "rule"           text COLLATE "pg_catalog"."default"       NOT NULL,
    "status"         varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
    "create_time"    int8                                      NOT NULL,
    "create_user_id" int8                                      NOT NULL,
    "update_time"    int8                                      NOT NULL,
    "update_user_id" int8                                      NOT NULL
)
;
ALTER TABLE "public"."permission_mock_rule" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."permission_mock_rule"."id" IS 'id';
COMMENT
ON COLUMN "public"."permission_mock_rule"."rule" IS 'mock规则';
COMMENT
ON COLUMN "public"."permission_mock_rule"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."permission_mock_rule"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."permission_mock_rule"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."permission_mock_rule"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."permission_mock_rule"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."permission_mock_rule" IS '接口mock数据规则表';

-- ----------------------------
-- Records of permission_mock_rule
-- ----------------------------
BEGIN;
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (613, '{
    "sql": null
}', '1', 1690912862251, 1, 1690912862251, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (648, '{
    "id": 1
}', '1', 1698890292586, 22, 1698890292586, 22);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (663, '{"content":"@cname"}', '1', 1691043323632, 1, 1691043398249, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (685, '{
  "content": "@cname",
  "children|1-10": [{
    "content": "@cname"
  }]
}', '1', 1694435545811, 1, 1694436441521, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (686, '{}', '1', 1698891607528, 22, 1698891607528, 22);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (688, '{"id":"/[1-9][0-9]{0,2}/","des":"@cname","img":"@cname","url":"@cname","sort":"/[1-9][0-9]{0,2}/"}', '1',
        1699011370680, 1, 1699413407908, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (689, '{}', '1', 1699011619048, 1, 1699011619048, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (690, '{
  "id|1-10": 1
}', '1', 1699011370688, 1, 1699011370688, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (691, '{"des":"@cname","img":"@cname","url":"@cname","sort":"/[1-9][0-9]{0,2}/"}', '1', 1699011370693, 1,
        1699413336733, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (692, '{}', '1', 1699154179938, 1, 1699154179938, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (709,
        '{"id":"/[1-9][0-9]{0,2}/","img":"@cname","file":"@cname","number":"/[1-9][0-9]{0,2}/","rich_text":"@cname","select_box":"@cname","normal_text":"@cname"}',
        '1', 1699422494657, 1, 1699979527253, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (710, '{}', '1', 1699422494661, 1, 1699422494661, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (711, '{
  "id|1-10": 1
}', '1', 1699422494666, 1, 1699422494666, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (712,
        '{"img":"@cname","file":"@cname","number":"/[1-9][0-9]{0,2}/","rich_text":"@cname","select_box":"@cname","normal_text":"@cname"}',
        '1', 1699422494671, 1, 1699979523076, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (744,
        '{"id":"/[1-9][0-9]{0,2}/","pid":"/[1-9][0-9]{0,2}/","icon":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","is_hot":"1"}',
        '1', 1718759537581, 1, 1718759587730, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (745, '{}', '1', 1718759537586, 1, 1718759537586, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (746, '{
  "id|1-10": 1
}', '1', 1718759537590, 1, 1718759537590, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (747, '{"pid":"/[1-9][0-9]{0,2}/","icon":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","is_hot":"1"}', '1',
        1718759537595, 1, 1718759581160, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (751,
        '{"id":"/[1-9][0-9]{0,2}/","name":"@cname","sort":"/[1-9][0-9]{0,2}/","tags":"@cname","intro":"@cname","position":"@cname"}',
        '1', 1719215514206, 1, 1719215860956, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (752, '{}', '1', 1719215514210, 1, 1719215514210, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (753, '{
  "id|1-10": 1
}', '1', 1719215514214, 1, 1719215514214, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (754, '{"name":"@cname","sort":"/[1-9][0-9]{0,2}/","tags":"@cname","intro":"@cname","position":"@cname"}', '1',
        1719215514218, 1, 1719215855194, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (757, '{"id":"/[1-9][0-9]{0,2}/","name":"@cname"}', '1', 1719221261412, 1, 1719221292834, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (758, '{}', '1', 1719221261417, 1, 1719221261417, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (759, '{
  "id|1-10": 1
}', '1', 1719221261424, 1, 1719221261424, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (760, '{"name":"@cname"}', '1', 1719221261432, 1, 1719221289091, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (765,
        '{"id":"/[1-9][0-9]{0,2}/","img":"@cname","file":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","position":"/[1-9][0-9]{0,2}/"}',
        '1', 1719307946398, 1, 1719361244118, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (766, '{}', '1', 1719307946413, 1, 1719307946413, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (767, '{
  "id|1-10": 1
}', '1', 1719307946432, 1, 1719307946432, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (768,
        '{"img":"@cname","file":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","position":"/[1-9][0-9]{0,2}/"}',
        '1', 1719307946438, 1, 1719361239642, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (770,
        '{"id":"/[1-9][0-9]{0,2}/","img":"@cname","file":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","position":"/[1-9][0-9]{0,2}/"}',
        '1', 1719362171840, 1, 1719362171840, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (771, '{}', '1', 1719362171845, 1, 1719362171845, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (772, '{
  "id|1-10": 1
}', '1', 1719362171849, 1, 1719362171849, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (773,
        '{"img":"@cname","file":"@cname","name":"@cname","sort":"/[1-9][0-9]{0,2}/","position":"/[1-9][0-9]{0,2}/"}',
        '1', 1719362171855, 1, 1719362171855, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (775,
        '{"id":"/[1-9][0-9]{0,2}/","name":"@cname","sort":"/[1-9][0-9]{0,2}/","end_time":"/[1-9][0-9]{0,2}/","on_shelf":"1","quantity":"/[1-9][0-9]{0,2}/","start_time":"/[1-9][0-9]{0,2}/","amount_full":"/[1-9][0-9]{0,2}/","amount_reduce":"/[1-9][0-9]{0,2}/","received_quantity":"/[1-9][0-9]{0,2}/","specified_product":"1","designated_products":"@cname"}',
        '1', 1720516039904, 1, 1720518707475, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (776, '{}', '1', 1720516039907, 1, 1720516039907, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (777, '{
  "id|1-10": 1
}', '1', 1720516039911, 1, 1720516039911, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (778,
        '{"name":"@cname","sort":"/[1-9][0-9]{0,2}/","end_time":"/[1-9][0-9]{0,2}/","on_shelf":"Number(1)","quantity":"/[1-9][0-9]{0,2}/","start_time":"/[1-9][0-9]{0,2}/","amount_full":"/[1-9][0-9]{0,2}/","amount_reduce":"/[1-9][0-9]{0,2}/","received_quantity":"/[1-9][0-9]{0,2}/","specified_product":"Number(1)","designated_products":"[]"}',
        '1', 1720516039915, 1, 1720537019898, 1);
INSERT INTO "public"."permission_mock_rule" ("id", "rule", "status", "create_time", "create_user_id", "update_time",
                                             "update_user_id")
VALUES (779, '{
}', '1', 1720751980895, 1, 1720753577407, 1);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS "public"."role";
CREATE TABLE "public"."role"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "status"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."role" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."role"."id" IS 'id';
COMMENT
ON COLUMN "public"."role"."name" IS '角色名';
COMMENT
ON COLUMN "public"."role"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."role"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."role"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."role"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."role"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."role" IS '角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO "public"."role" ("id", "name", "status", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (1, '管理员', '1', 0, 0, 1718423083515, 1);
COMMIT;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS "public"."role_menu";
CREATE TABLE "public"."role_menu"
(
    "role_id" int8 NOT NULL,
    "menu_id" int8 NOT NULL
)
;
ALTER TABLE "public"."role_menu" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."role_menu"."role_id" IS '角色id';
COMMENT
ON COLUMN "public"."role_menu"."menu_id" IS '菜单id';
COMMENT
ON TABLE "public"."role_menu" IS '角色菜单关系表';

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 2);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 3);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 4);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 29);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 31);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 34);
INSERT INTO "public"."role_menu" ("role_id", "menu_id")
VALUES (1, 35);
COMMIT;

-- ----------------------------
-- Table structure for role_module
-- ----------------------------
DROP TABLE IF EXISTS "public"."role_module";
CREATE TABLE "public"."role_module"
(
    "role_id"   int8 NOT NULL,
    "module_id" int8 NOT NULL
)
;
ALTER TABLE "public"."role_module" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."role_module"."role_id" IS '角色id';
COMMENT
ON COLUMN "public"."role_module"."module_id" IS '模块id';
COMMENT
ON TABLE "public"."role_module" IS '角色模块关系表';

-- ----------------------------
-- Records of role_module
-- ----------------------------
BEGIN;
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 8);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 13);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 14);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 17);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 19);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 20);
INSERT INTO "public"."role_module" ("role_id", "module_id")
VALUES (1, 21);
COMMIT;

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS "public"."teacher";
CREATE TABLE "public"."teacher"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "img"            varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "position"       text COLLATE "pg_catalog"."default",
    "position_id"    int8,
    "tag"            text COLLATE "pg_catalog"."default",
    "intro"          text COLLATE "pg_catalog"."default"         NOT NULL,
    "sort"           int8                                        NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."teacher" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."teacher"."id" IS '主键';
COMMENT
ON COLUMN "public"."teacher"."name" IS '姓名';
COMMENT
ON COLUMN "public"."teacher"."img" IS '照片';
COMMENT
ON COLUMN "public"."teacher"."position" IS '职位';
COMMENT
ON COLUMN "public"."teacher"."position_id" IS '职位id|';
COMMENT
ON COLUMN "public"."teacher"."tag" IS '标签';
COMMENT
ON COLUMN "public"."teacher"."intro" IS '简介|';
COMMENT
ON COLUMN "public"."teacher"."sort" IS '排序';
COMMENT
ON COLUMN "public"."teacher"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."teacher"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."teacher"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."teacher"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."teacher" IS '师资管理表';

-- ----------------------------
-- Records of teacher
-- ----------------------------
BEGIN;
INSERT INTO "public"."teacher" ("id", "name", "img", "position", "position_id", "tag", "intro", "sort", "create_time",
                                "create_user_id", "update_time", "update_user_id")
VALUES (2, '胡冬', 'https://s3.cn-north-1.amazonaws.com.cn/qingshuxuetang.com/YXK/teacher/teacher-6.png', '[71, 72]',
        72, '[5, 4]',
        '<p>高分通过税务师、会计师、审计师、注册纳税筹划师，被财政部列为安徽省职称考试金银榜优秀考生，有多年的考证类课程与实操类课程辅导经验，曾在大中型企业及上市公司任职财务经理，具有深湛的财税理论基础及丰富的财税实战经验，擅长用图表“翻译”教材中的重难点。</p>',
        1, 1719222282714, 1, 1719394459425, 1);
COMMIT;

-- ----------------------------
-- Table structure for teacher_tag
-- ----------------------------
DROP TABLE IF EXISTS "public"."teacher_tag";
CREATE TABLE "public"."teacher_tag"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."teacher_tag" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."teacher_tag"."id" IS '主键';
COMMENT
ON COLUMN "public"."teacher_tag"."name" IS '名称';
COMMENT
ON COLUMN "public"."teacher_tag"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."teacher_tag"."create_user_id" IS '创建用户ID';
COMMENT
ON COLUMN "public"."teacher_tag"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."teacher_tag"."update_user_id" IS '更新用户ID';
COMMENT
ON TABLE "public"."teacher_tag" IS '师资标签表';

-- ----------------------------
-- Records of teacher_tag
-- ----------------------------
BEGIN;
INSERT INTO "public"."teacher_tag" ("id", "name", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (1, '金牌讲师', 1719221361014, 1, 1719221854679, 1);
INSERT INTO "public"."teacher_tag" ("id", "name", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (3, '资深博士', 1719276129782, 1, 1719276129782, 1);
INSERT INTO "public"."teacher_tag" ("id", "name", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (4, '逻辑性强', 1719287780869, 1, 1719287780869, 1);
INSERT INTO "public"."teacher_tag" ("id", "name", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (5, '接地气', 1719287791217, 1, 1719287791217, 1);
INSERT INTO "public"."teacher_tag" ("id", "name", "create_time", "create_user_id", "update_time", "update_user_id")
VALUES (6, '专业培训讲师', 1719287806019, 1, 1719287806019, 1);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS "public"."user";
CREATE TABLE "public"."user"
(
    "id"             int8                                        NOT NULL,
    "name"           varchar(10) COLLATE "pg_catalog"."default"  NOT NULL,
    "account"        varchar(20) COLLATE "pg_catalog"."default"  NOT NULL,
    "password"       varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "role_id"        text COLLATE "pg_catalog"."default",
    "wx_union_id"    varchar(100) COLLATE "pg_catalog"."default",
    "wx_gzh_open_id" varchar(100) COLLATE "pg_catalog"."default",
    "wx_xcx_open_id" varchar(100) COLLATE "pg_catalog"."default",
    "domain"         text COLLATE "pg_catalog"."default"         NOT NULL,
    "admin"          varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "status"         varchar(1) COLLATE "pg_catalog"."default"   NOT NULL,
    "create_time"    int8                                        NOT NULL,
    "create_user_id" int8                                        NOT NULL,
    "update_time"    int8                                        NOT NULL,
    "update_user_id" int8                                        NOT NULL
)
;
ALTER TABLE "public"."user" OWNER TO "postgres";
COMMENT
ON COLUMN "public"."user"."id" IS 'id';
COMMENT
ON COLUMN "public"."user"."name" IS '名字';
COMMENT
ON COLUMN "public"."user"."account" IS '账号';
COMMENT
ON COLUMN "public"."user"."password" IS '密码';
COMMENT
ON COLUMN "public"."user"."role_id" IS '角色：逗号分隔';
COMMENT
ON COLUMN "public"."user"."wx_union_id" IS '开放平台绑定小程序和公众后每个用户特有的id';
COMMENT
ON COLUMN "public"."user"."wx_gzh_open_id" IS '公众号用户的openId';
COMMENT
ON COLUMN "public"."user"."wx_xcx_open_id" IS '小程序用户的openId';
COMMENT
ON COLUMN "public"."user"."domain" IS '登录域：PC/WX/H5，多个域逗号分隔';
COMMENT
ON COLUMN "public"."user"."admin" IS '超管';
COMMENT
ON COLUMN "public"."user"."status" IS '状态：无用';
COMMENT
ON COLUMN "public"."user"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."user"."create_user_id" IS '创建人id';
COMMENT
ON COLUMN "public"."user"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."user"."update_user_id" IS '更新人id';
COMMENT
ON TABLE "public"."user" IS '用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO "public"."user" ("id", "name", "account", "password", "role_id", "wx_union_id", "wx_gzh_open_id",
                             "wx_xcx_open_id", "domain", "admin", "status", "create_time", "create_user_id",
                             "update_time", "update_user_id")
VALUES (1, '蓝姆c', 'lanmuc', '$2a$10$PBG26WFYhiUfuZXdTXmmD./eC7THuAsy7espJzQHaYOKf7HJufWbG', '1', NULL, NULL, NULL,
        'PC,WX,H5', '1', '1', 0, 0, 1671282469802, 1);
COMMIT;

-- ----------------------------
-- View structure for view_name
-- ----------------------------
DROP VIEW IF EXISTS "public"."view_name";
CREATE VIEW "public"."view_name" AS
SELECT a.table_name,
       a.table_comment,
       string_agg(a.column_name::text, ','::text ORDER BY a.ordinal_position)                  AS param,
       ('['::text || array_to_string(array_agg(a.jsonstring), ','::text)) || ']'::text AS info, json_object_agg(a.column_name, a.column_comment) AS param_info,
       json_object_agg(a.column_name,
                       CASE
                           WHEN a.data_type::text = 'bit'::text THEN 'Number(1)'::text
                           WHEN a.data_type::text ~~ '%char%'::text OR a.data_type::text ~~ '%text%'::text THEN '@cname'::text
            WHEN a.data_type::text = 'json'::text THEN '[]'::text
            WHEN a.data_type::text ~~ '%int%'::text OR a.data_type::text ~~ '%decimal%'::text THEN '/[1-9][0-9]{0,2}/'::text
            ELSE ''::text
        END) AS param_mock,
       json_object_agg(a.column_name, jsonb_build_object('type',
                                                         CASE
                                                             WHEN a.data_type::text = 'bit'::text THEN 'boolean'::text
                                                             WHEN a.data_type::text ~~ '%char%'::text OR a.data_type::text ~~ '%text%'::text OR a.data_type::text = 'json'::text THEN 'string'::text
            WHEN a.data_type::text ~~ '%int%'::text OR a.data_type::text ~~ '%decimal%'::text THEN 'number'::text
            ELSE ''::text
        END, 'required',
                                                         CASE
                                                             WHEN a.is_nullable::text = 'YES'::text THEN 0
                                                             ELSE 1
                                                             END))                             AS param_valid
FROM (SELECT a_1.table_type,
             a_1.table_comment,
             cn.column_comment,
             jsonb_build_object('name', b.column_name, 'type',
                                CASE
                                    WHEN b.udt_name::name = 'bit'::name THEN 'boolean'::text
                                    WHEN b.udt_name::name ~~ '%char%'::text OR b.udt_name::name ~~ '%text%'::text OR b.udt_name::name = 'json'::name THEN 'string'::text
                    WHEN b.udt_name::name ~~ '%int%'::text OR b.udt_name::name ~~ '%decimal%'::text THEN 'number'::text
                    ELSE ''::text
                END, 'des', cn.column_comment, 'sort', b.ordinal_position) AS jsonstring,
             b.table_catalog,
             b.table_schema,
             b.table_name,
             b.column_name,
             b.ordinal_position,
             b.column_default,
             b.is_nullable,
             b.data_type,
             b.character_maximum_length,
             b.character_octet_length,
             b.numeric_precision,
             b.numeric_precision_radix,
             b.numeric_scale,
             b.datetime_precision,
             b.interval_type,
             b.interval_precision,
             b.character_set_catalog,
             b.character_set_schema,
             b.character_set_name,
             b.collation_catalog,
             b.collation_schema,
             b.collation_name,
             b.domain_catalog,
             b.domain_schema,
             b.domain_name,
             b.udt_catalog,
             b.udt_schema,
             b.udt_name,
             b.scope_catalog,
             b.scope_schema,
             b.scope_name,
             b.maximum_cardinality,
             b.dtd_identifier,
             b.is_self_referencing,
             b.is_identity,
             b.identity_generation,
             b.identity_start,
             b.identity_increment,
             b.identity_maximum,
             b.identity_minimum,
             b.identity_cycle,
             b.is_generated,
             b.generation_expression,
             b.is_updatable
      FROM (SELECT tables.table_catalog,
                   tables.table_schema,
                   tables.table_name,
                   tables.table_type,
                   d.description AS table_comment
            FROM information_schema.tables
                     LEFT JOIN pg_class c ON c.relname = tables.table_name::name
                     LEFT JOIN pg_description d
            ON d.objoid = c.oid AND d.objsubid = 0
            WHERE tables.table_schema:: name = 'public':: name) a_1
               LEFT JOIN information_schema.columns b ON a_1.table_name::name = b.table_name::name AND a_1.table_schema::name = b.table_schema::name
             LEFT JOIN ( SELECT a_2.attname AS column_name,
                    c.relname AS table_name,
                    col_description(a_2.attrelid, a_2.attnum::integer) AS column_comment
                   FROM pg_class c,
                    pg_attribute a_2
                  WHERE a_2.attrelid = c.oid) cn
      ON cn.table_name = b.table_name:: name AND cn.column_name = b.column_name:: name) a
GROUP BY a.table_name, a.table_comment
ORDER BY a.table_name;
ALTER TABLE "public"."view_name" OWNER TO "postgres";

-- ----------------------------
-- View structure for table_info
-- ----------------------------
DROP VIEW IF EXISTS "public"."table_info";
CREATE VIEW "public"."table_info" AS
SELECT a.table_name,
       a.table_comment,
       string_agg(a.column_name::text, ','::text ORDER BY a.ordinal_position)                  AS param,
       ('['::text || array_to_string(array_agg(a.jsonstring), ','::text)) || ']'::text AS info, json_object_agg(a.column_name, a.column_comment) AS param_info,
       json_object_agg(a.column_name,
                       CASE
                           WHEN a.data_type::text = 'bit'::text THEN 'Number(1)'::text
                           WHEN a.data_type::text ~~ '%char%'::text OR a.data_type::text ~~ '%text%'::text THEN '@cname'::text
            WHEN a.data_type::text = 'json'::text THEN '[]'::text
            WHEN a.data_type::text ~~ '%int%'::text OR a.data_type::text ~~ '%decimal%'::text THEN '/[1-9][0-9]{0,2}/'::text
            ELSE ''::text
        END) AS param_mock,
       json_object_agg(a.column_name, jsonb_build_object('type',
                                                         CASE
                                                             WHEN a.data_type::text = 'bit'::text THEN 'boolean'::text
                                                             WHEN a.data_type::text ~~ '%char%'::text OR a.data_type::text ~~ '%text%'::text OR a.data_type::text = 'json'::text THEN 'string'::text
            WHEN a.data_type::text ~~ '%int%'::text OR a.data_type::text ~~ '%decimal%'::text THEN 'number'::text
            ELSE ''::text
        END, 'required',
                                                         CASE
                                                             WHEN a.is_nullable::text = 'YES'::text THEN 0
                                                             ELSE 1
                                                             END))                             AS param_valid
FROM (SELECT a_1.table_type,
             a_1.table_comment,
             cn.column_comment,
             jsonb_build_object('name', b.column_name, 'type',
                                CASE
                                    WHEN b.udt_name::name = 'bit'::name THEN 'boolean'::text
                                    WHEN b.udt_name::name ~~ '%char%'::text OR b.udt_name::name ~~ '%text%'::text OR b.udt_name::name = 'json'::name THEN 'string'::text
                    WHEN b.udt_name::name ~~ '%int%'::text OR b.udt_name::name ~~ '%decimal%'::text THEN 'number'::text
                    ELSE ''::text
                END, 'des', cn.column_comment, 'sort', b.ordinal_position) AS jsonstring,
             b.table_catalog,
             b.table_schema,
             b.table_name,
             b.column_name,
             b.ordinal_position,
             b.column_default,
             b.is_nullable,
             b.data_type,
             b.character_maximum_length,
             b.character_octet_length,
             b.numeric_precision,
             b.numeric_precision_radix,
             b.numeric_scale,
             b.datetime_precision,
             b.interval_type,
             b.interval_precision,
             b.character_set_catalog,
             b.character_set_schema,
             b.character_set_name,
             b.collation_catalog,
             b.collation_schema,
             b.collation_name,
             b.domain_catalog,
             b.domain_schema,
             b.domain_name,
             b.udt_catalog,
             b.udt_schema,
             b.udt_name,
             b.scope_catalog,
             b.scope_schema,
             b.scope_name,
             b.maximum_cardinality,
             b.dtd_identifier,
             b.is_self_referencing,
             b.is_identity,
             b.identity_generation,
             b.identity_start,
             b.identity_increment,
             b.identity_maximum,
             b.identity_minimum,
             b.identity_cycle,
             b.is_generated,
             b.generation_expression,
             b.is_updatable
      FROM (SELECT tables.table_catalog,
                   tables.table_schema,
                   tables.table_name,
                   tables.table_type,
                   d.description AS table_comment
            FROM information_schema.tables
                     LEFT JOIN pg_class c ON c.relname = tables.table_name::name
                     LEFT JOIN pg_description d
            ON d.objoid = c.oid AND d.objsubid = 0
            WHERE tables.table_schema:: name = 'public':: name) a_1
               LEFT JOIN information_schema.columns b ON a_1.table_name::name = b.table_name::name AND a_1.table_schema::name = b.table_schema::name
             LEFT JOIN ( SELECT a_2.attname AS column_name,
                    c.relname AS table_name,
                    col_description(a_2.attrelid, a_2.attnum::integer) AS column_comment
                   FROM pg_class c,
                    pg_attribute a_2
                  WHERE a_2.attrelid = c.oid) cn
      ON cn.table_name = b.table_name:: name AND cn.column_name = b.column_name:: name) a
GROUP BY a.table_name, a.table_comment
ORDER BY a.table_name;
ALTER TABLE "public"."table_info" OWNER TO "postgres";

-- ----------------------------
-- Primary Key structure for table banner
-- ----------------------------
ALTER TABLE "public"."banner"
    ADD CONSTRAINT "banner_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table coupon
-- ----------------------------
CREATE INDEX "idx_name" ON "public"."coupon" USING btree (
    "name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    );

-- ----------------------------
-- Primary Key structure for table coupon
-- ----------------------------
ALTER TABLE "public"."coupon"
    ADD CONSTRAINT "coupon_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table course_category
-- ----------------------------
ALTER TABLE "public"."course_category"
    ADD CONSTRAINT "course_category_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table cron
-- ----------------------------
CREATE UNIQUE INDEX "tag" ON "public"."cron" USING btree (
    "tag" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    );

-- ----------------------------
-- Primary Key structure for table cron
-- ----------------------------
ALTER TABLE "public"."cron"
    ADD CONSTRAINT "cron_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table crud
-- ----------------------------
ALTER TABLE "public"."crud"
    ADD CONSTRAINT "crud_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table library
-- ----------------------------
ALTER TABLE "public"."library"
    ADD CONSTRAINT "library_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table low_code_permission
-- ----------------------------
CREATE UNIQUE INDEX "permission_id" ON "public"."low_code_permission" USING btree (
    "permission_id" "pg_catalog"."int8_ops" ASC NULLS LAST
    );

-- ----------------------------
-- Primary Key structure for table low_code_permission
-- ----------------------------
ALTER TABLE "public"."low_code_permission"
    ADD CONSTRAINT "low_code_permission_pkey" PRIMARY KEY ("permission_id");

-- ----------------------------
-- Primary Key structure for table material
-- ----------------------------
ALTER TABLE "public"."material"
    ADD CONSTRAINT "material_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table menu
-- ----------------------------
CREATE UNIQUE INDEX "path" ON "public"."menu" USING btree (
    "path" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    );

-- ----------------------------
-- Primary Key structure for table menu
-- ----------------------------
ALTER TABLE "public"."menu"
    ADD CONSTRAINT "menu_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table module
-- ----------------------------
ALTER TABLE "public"."module"
    ADD CONSTRAINT "module_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table module_permission
-- ----------------------------
CREATE INDEX "module_id" ON "public"."module_permission" USING btree (
    "module_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
    "permission_id" "pg_catalog"."int8_ops" ASC NULLS LAST
    );
